Entering a number

[WSB]

I am trying to enter the number 00333009 into a cell.

Any advice please.

Thank you.

 

[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

 

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

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Yes, that seems to work fine. Thanks for your help.