How do I get zero to display, ie. 01234

  • Thread starter Thread starter coyot1
  • Start date Start date
You can use a custom format but it means you have to have a fixed sets of
digits to display

0000

as an example would return 0567 but it would also return 1234 and not 01234




--


Regards,


Peo Sjoblom
 
Format the cell as text before you enter your data and precede the data
with an apostrophe. ex. '0543 the apostrophe will not show in the cell.
Regards
Cimjet
 
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

delete leading 0 2
Addiing a Zero to a number which is already there 1
How to show a leading 0 in a cell. 2
Display Leading Zero 1
Help! Excel keeps removing the first zero 4
Leading Zero 11
How to stop Excel from automatically truncating leading zeros 2
How can you format cells in a column to display a 50 digit binary 3

Back
Top