entering numbers with 0 in front of them

S

Sha

I am trying to make a chart where the numbers happened to
be listed with 0s as the first number 0133, 0244 and so on
but excel won't let me leave the zero in front it keeps
removing it. Anyone know how to turn this function off.
Thanks
 
R

RagDyer

<Format> <Cells> <Number> tab,
Click "Custom" and enter:
0000
into the "Type" box,
<OK>
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am trying to make a chart where the numbers happened to
be listed with 0s as the first number 0133, 0244 and so on
but excel won't let me leave the zero in front it keeps
removing it. Anyone know how to turn this function off.
Thanks
 
G

Guest

Format the cells with the Custom format code 0### where
the number of # equals the total number of digits. So,
using your example, format all the cells in the
workmsheet with the custom format code 0###, then create
the chart using that selected data and the chart's valuew
axis will be so formatted as well.
 
G

grace

In a spreadsheet you can try typing an apostrophe ' then the number. Press enter and the apostrophe should not appear.
 
J

Jack

Grace
Becareful with that process. It changes the data into a text value and you cannot add them together. The other two responses allow formatted output and mathmatical calculations to boot
Jack
 
Top