How do I type in a number that begins with zero?

G

Guest

I want to type in mobile phone numbers that start with a zeio but when I do,
the zero is omitted - how do I stop this from happening?
excel 2003
 
N

Niek Otten

Start with a single quote. It will not display, but will cause the number to
be treated as text.
Another way is to format the cells as text before entering the numbers.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
I

Ian Ripsher

Blindie00 said:
I want to type in mobile phone numbers that start with a zeio but when I
do,
the zero is omitted - how do I stop this from happening?
excel 2003
Click to expand...
If you want them to be formatted as numbers, select the cells/col where the
mobile nos are to go and go to Format Cells | Number | Custom and set up a
format "mask" in the "Typ" box on the RHS with a leading zero. For example,
if (like in the UK) mobile nos are of the format 07xxx xxx xxx, enter the
mask as 0#### ### ### [with a space between the groups]. The number will
then be formatted as you wish.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to show numbers that begin with 0 in excel 2
Displaying zeros in cells 2
How can I keep a zero at the beginning of a mobile number? 3
How do I begin value with the number zero? 2
display zero values at the beginning of a number. 2
How do I show zeros? 2
how to display zero prefixes in worksheet cells such as phone numb 1
How to arrange number? 9

Top