PDA

View Full Version : Cell phone number display in Excel



Colpol
29-08-2008, 07:29 PM
How do I get Excel to display the zero at the start of a cell phone number. Have tried all the formats but all delete the zero when I click OK
I have done this before but can't remember how to do it.

Cheers
Colin

stormdragon
29-08-2008, 07:32 PM
Formatting the cells as "Text" will leave any zeros in place.

Colpol
29-08-2008, 07:34 PM
Thank you:) :

Found the answer. If you make it Text it comes up with error(which you can ignore).
Found that if you put spaces in the number it leaves the zero in place(No Error)

stormdragon
29-08-2008, 07:44 PM
No probs