how do in input phone numbers starting with 0 into excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i tried to input mobile phone numbers into an excel spreadsheet but the 0 at
the beginning always disappears. Does anyone know how to rectify this problem?
 
Try formatting the cell and changing it to a text format. This will allow
the 0 to remain at the start.

If you need help doing this, please just reply.

Cheers,
Matt
 
There's a telephone number format that might work. It's based on your OS
regional settings. Format>Cells>Number tab>Special.

If that doesn't work then you can preformat the cell as TEXT or precede the
entry with an apostrophe: '020-10-555-1212

Biff
 
I can give you an expert level answer that absolutely will work. But, I
first need to know if ALL the numbers are exactly 10 digits.
 

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

cleaning numbers 2
how to show numbers that begin with 0 in excel 2
Format appears stuck..how to break formatting 2
Buying a modern phone help needed. ;-) 14
Word Create a Phone Book using MailMerge in word 2007 0
data sorting with dates 2
How add a digit to front of number in each cell in excexl column 1
how to display zero prefixes in worksheet cells such as phone numb 1

Back
Top