How do I allow a cell to display a 0 as the first digit

C

CaptainWebe

I am including pager numbers on a list and need to have 099 or 025 as a cell
value. But excel automatically omits the "0". I have tried General and
Number formatting.
 
D

David Biddulph

Format the cell as text before you insert the number, or
Precede the number by an apostrophe, or
Format as 000
 

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

Keep First Letters, with exceptions 0
Improving Macro That Keeps First Letter 0
Paste to excel from word - auto format problem 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Omitting the whole number when formatting decimals 11
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Truncating Number Series 3
Drop down list control value in vba 2

Top