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

S

shiva

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

Max

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
 
S

shiva

Thanks.Your solution worked perfectly.
Max said:
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
Click to expand...
 
Top