Zeros Not Showing

[jkjmwilliams]

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

 

[Mike H]

Hi,

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

Mike

 

[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

 

[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

 

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