how to get zero befor no. means eg 065 in excel

[Guest]

Hi,
I want to have zero befor any number in excel sheet but whenever I write
automatically it disapperas(eg when I write 065 automaticaaly 0 disapperas
and remains only 65)So if anyone know the way to solve this problem please
help.

 

[Guest]

To retain it as number, pre-format the col as Custom, Type: 000

If having it as text is okay, then enter it as text, either precede the
entry with an apostrophe (type: '065 ), or pre-format the col as "Text"
before entering

 

[Guest]

Thanks.Your solution worked perfectly.

To retain it as number, pre-format the col as Custom, Type: 000

If having it as text is okay, then enter it as text, either precede the
entry with an apostrophe (type: '065 ), or pre-format the col as "Text"
before entering

 

[Max]

Shiva, you're welcome !