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

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!
 
T

trip_to_tokyo

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!

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.
 

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

Top