number format

  • Thread starter Thread starter cheri
  • Start date Start date
C

cheri

i have a column set up in number format, in a lot of places the first number
is 0, (zero). after i enter my info it always drops the 0. How do I correct
this? I need the 0 to be there
 
Two ways:

1. type a single quote (apostrophe) before the set of digits
2. if the set of digits is fixed in length, say four, then format the cell
as custom
0000
 

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

Displaying zeros in cells 2
Default number format in Excel 1
Custom Format - Show 12.5 but not 12.0 (drop .0s) ? 2
Formatting zeros as dashes 4
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Formating Numbers 11
Numbers showing Up Centered in Cell ? 1
my zero keeps dropping even though formatted as text 3

Back
Top