Leading zeros in Cell

[Dennis Hansen]

I can not get the leading zeros to show in my cells
I have gone to tools, veiw tab and selected the zero
values button and deselected it, and no luck
I need to show zeros as I input them

0125
0158
and when I enter the number it cuts the zero out
how can I fix this. a tad bit frustrated
thank you so much for all the help this site has given me.

dennis hansen

 

[mudraker]

You can format the cells to display a set number of digits. Excel wil
still drop the leading 0's but display them. This means if you copy th
data you will not have the leading 0's


another way is to format the cell as text or enter a ' followed by you
number. ' forces a numeric entry to be entered as text. the ' will no
be displayed in the cel

 

[rlh]

In order to get the leading zeros in a cell to show or print you must type a single quotation mark at the beginning of the line. For example: '000032

The quotation mark tells the program to show and print exactly what is input into the cell

Hope this helps you.

 

[CLR]

Select the cell (s) or entire column, then Right-click > Firmat cells >
Number Tab > Text > OK.................this pre-formats the cell(s) as
"Text" which will accept your leading zeros without having to enter the
apostrophe first.


Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

Dennis

Either pre-format the cells as TGext before entering the numbers or enter an
apostrophe then the number.

If you need them as numbers but look like 0123 and 0158 then.........

Format>Cells>Number>Custom "0000"(no quotes)

Gord Dibben Excel MVP