format a cell with a phone number - how?

  • Thread starter Thread starter Martin ©¿©¬
  • Start date Start date
M

Martin ©¿©¬

Hi
I have a cell with a moblle phone number
0xxxxxxxxxx (11 numbers) & the 0 doesn't show?
Why is that & how do I fix please?
 
You could format the cell to show 11 digits:

Format|Cells|Number tab|custom category
00000000000

Or you could precede your entry with an apostrophe:
'12341234123

Or you could format the cell as Text, then do the data entry.
 
Precede the number with an apostrophe (single quote) when typing the number.
 
Select range... Right click... Format cells....Special---Phone number
 
Precede the number with an apostrophe (single quote) when typing the number.

Thank you all for your replies
Precede the number with an apostrophe did the trick
 

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

Back
Top