In Excel, when i key in 02352 and press enter, the zero goes off

  • Thread starter Thread starter Query
  • Start date Start date
Q

Query

In Excel, when i key in any group of numbers with a zero preceding it, and
then press enter, the zero disappears. How do i for instance key in 02352.
with the zero still intact when i press enter. Please help!
 
In Excel, when i key in any group of numbers with a zero preceding it, and
then press enter, the zero disappears.  How do i for instance key in 02352.
with the zero still intact when i press enter.  Please help!
Click to expand...

EXCEL 2007

Format the cell(s) as text (Home / Font group / click on arrow in
lower right hand corner / Format Cells should launch / Number tab /
Text / OK).

If my comments have helped please hit Yes.

Thanks.
 
Back
Top