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

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

Similar Threads

VBA word change keys 0
Interchange line break and paragraph break shortcut keys 9
when I type zero cell is blank 4
how to insert serial numbers to rows? 3
Force zeros in Excel 2007 when cells blank and keep commas for thousands 0
Excel Bug 0
Excel2007 Stipulate where cursor goes when Enter Key pressed 5
Starting with a zero? 3

Top