How can can I enter 023023 in a cell without losing the first 0

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

Guest

Hi, does anybody know how I can enter the number 023023 in a cell without
automatically losing the first zero ?
 
Yes, that will work, but I understand the askers concern. Is there a way to
retain the beginning '0' and keep the cell in number format? There are MANY
reasons (at least for myself) that I need to be able to keep it in number
format. Yes, the leading '0' is absolutely necessary for me to retain.
 
Hi, does anybody know how I can enter the number 023023 in a cell without
automatically losing the first zero ?
Click to expand...

Format the cell:

Format/Cells/Number/Custom Type: 000000


--ron
 
What are a couple of the many things you want to do that you can't do using
this solution?
 
Format the cell as 000000
--
David Biddulph

Ean Wilson said:
Yes, that will work, but I understand the askers concern. Is there a way
to
retain the beginning '0' and keep the cell in number format? There are
MANY
reasons (at least for myself) that I need to be able to keep it in number
format. Yes, the leading '0' is absolutely necessary for me to retain.
Click to expand...
 
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

Best way to migrate PST to Thunderbird without losing emails? 1
Insert multiple .dat files into one pdf without losing color of their graphs 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel Excel 2013 cell text hidden whilst typing 5
Displaying zeros in cells 2
combining data in multiple cells 1
#DIV/0! error 1
Entering a Text Symbol ? 2

Back
Top