W
WSB
I am trying to enter the number 00333009 into a cell.
Any advice please.
Thank you.
Any advice please.
Thank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
You can enter it with an apostrophe in front to preserve the leading
zeros, i.e. '00333009. Or you could format the cell first to Text,
then enter 00333009. In both cases the number would be treated as a
text value, so you could not do any arithmetic directly on it.
Alternatively, you could enter 333009 and format the cell using Custom
as "00000000" and this will give you the leading zeros and this will
be treated as a number.
Hope this helps.
Pete
zeros, i.e. '00333009. Or you could format the cell first to Text,
then enter 00333009. In both cases the number would be treated as a
text value, so you could not do any arithmetic directly on it.
Alternatively, you could enter 333009 and format the cell using Custom
as "00000000" and this will give you the leading zeros and this will
be treated as a number.
Hope this helps.
Pete
W
WSB
Alternatively, you could enter 333009 and format the cell using Custom
as "00000000" and this will give you the leading zeros and this will
be treated as a number.
Yes, that seems to work fine. Thanks for your help.
P
Pete_UK
You're welcome - thanks for feeding back.
Pete
Pete
Yes, that seems to work fine. Thanks for your help.