Donate SIGN UP
Home > Technology > Excel 2007 problem

Excel 2007 problem

Avatar Image
MTbowels | 22:10 Sat 29th May 2010 | Technology
6 Answers
I'm compiling a spreadsheet in which I need to enter a mobile number beginning 07875..... I can type the number in the selected cell, but when I move to another cell, the "0" disappeares leaving the number as 7875.....
How can I stop Excel deleting the 0?

Thanks.
prev O2 Home Phone Package versus BT
  
next Cardmania,satonline.co.uk
Gravatar

Answers

1 to 6 of 6rss feed

Best Answer

No best answer has yet been selected by MTbowels. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image factor-fiction
Instead of typing
07875
type
'07875
22:11 Sat 29th May 2010
Avatar Image MarkRae
Type an apostrophe (') at the beginning of the number. That tells Excel to treat anything which follows as plain text and not to try to interpret it as a number or a date or a formula or whatever...
22:12 Sat 29th May 2010
Avatar Image boxtops
I have the same problem so would be interested if there is a solution. I have got round this by typing the capital letter O instead of the zero. It does it on landline numbers too. It may be a formatting matter but I can't get it to stop doing this at the moment.
22:13 Sat 29th May 2010
Avatar Image MTbowels
Question Author
That's Brilliant! Thank you for your quick responses - it works like a dream.

Boxtops, I'm glad to see I'm not the only one with this problem!
22:18 Sat 29th May 2010
Avatar Image VHG
Why not change the Cell to "text" format rather than "number" format

Text leaves it exactly as it is.
22:21 Sat 29th May 2010
Avatar Image factor-fiction
Yes, just shows there are many ways to skin a cat (or is it rabbit)
22:21 Sat 29th May 2010

1 to 6 of 6rss feed

Do you know the answer?

Excel 2007 problem

Answer Question >>