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

Hi,

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

Mike

"jkjmwilliams" wrote:

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

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


"jkjmwilliams" wrote:

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

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

"jkjmwilliams" wrote in message
...
How do I force numbers beginning with a zero to show? EX: 05678

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.
--
David Biddulph

"jkjmwilliams" wrote in message
...
How do I force numbers beginning with a zero to show? EX: 05678