Zeros Not Showing


J

jkjmwilliams

How do I force numbers beginning with a zero to show? EX: 05678
 
Ad

Advertisements

M

Mike H

Hi,

Put an apostrophe ' in front of them before you type the number or format as
text.

Mike
 
F

FSt1

hi
with true numbers, leading zeros are unnecessary so xl drops them. preformat
the cell as text or being input with a leading apostrophe.
you can create a custom format such as "00000" but this would only make the
number to "appear" to have a leading zero. in the fomula bar, there would be
no leading zero. this creates problems when you try to export becasue the
leading zero is not really there. it may create problem when you copy/paste
but that depends.

Regards
FSt1
 
P

Pete_UK

If you are typing these values in, then you can pre-format the cells as
text, or you could enter the value with a leading apostrophe, like this:
'05678 - the apostrophe will not show in the cell.

Hope this helps.

Pete
 
Ad

Advertisements

D

David Biddulph

Custom format as 00000
or format as text before you type in the number,
or precede the number with an apostrophe.

The latter two options will leave you with text, rather than a number, so
further calculations may well be affected.
 

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

Show Zeros 1
Show zero 2
Show zero values 4
Showing Zero amounts 2
Show leading zeros. 6
showing zero in cell 5
show zero as dash 2
Format that shows Zero 3

Top