Typing Numbers

[nischal448]

Hi,

I am trying to type 001, 002 , 003, etc, in rows, however its taking the value 1, 2, 3 etc, can anyone help?

 

[Richard Schollar]

Hi

If this is purely for display, then you can format the cells to display the leading zeros (Format>Cells>Number tab and choose Custom and type in:

000

in the type box at the top.

If you want actual textual values ie "001" then you can either format the cells as Text and type away, or precede the values you are inputting with an apostrophe ie:

'001

as this makes the cell text too.