Zeros Not Showing

  • Thread starter Thread starter jkjmwilliams
  • Start date Start date
Hi,

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

Mike
 
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
 
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
 
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.
 
Back
Top