In Excel how can i enter in a value like 0021 without the zeros .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel how can i enter in a value like 0021 without the zeros disappearing
and leaving me with just 21?
 
You must log in or register to reply here.

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

Formula or script needed 1
find a value at an intersection? 4
Formula needed please 3
In Excel, when i key in 02352 and press enter, the zero goes off 1
vlookup instructions,, or help making a formula 7
Difference of empty cell and zero value when formatting 4
Displaying zeros in cells 2
Can I get date in this format? 1

Back
Top