numbers starting with 0

  • Thread starter Thread starter mccomb
  • Start date Start date
M

mccomb

I have a group of 6 digit numbers starting with "0". When I enter this in
the cell, it shows up in the cell correctly. BUT up above the 0 gets
dropped. I need the 0 to stay there. What can I do so the 0 does not drop
off in the top box.
 
1) type an apostrophe (single quote) before the number; it will not be
displayed or printed
or
2) use a custom format of: 000000
best wishes
 
You can enter the numbers with an apostrophe in front of them, like:

'012345

The apostrophe will not show in the cell - this tells Excel to treat
the cell as text.

Or, you could pre-format the cells as text before entering your
numbers.

Or, you could apply a Custom format to the cells, set as "000000" -
the numbers will be treated as numbers and can be used in
calculations.

Hope this helps.

Pete
 
One way is to preformat the col as TEXT
Or, enter a preceding apostrophe
(both ways above will result in text numbers)

Alternatively, if you need it to remain as real numbers but appear displayed
with the preceding zeros, try preformatting the col as Custom, Type: 000000
Then just enter the nums as per normal.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
 
Back
Top