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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shiva - 27 Oct 2006 06:48 GMT

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.

Reply to this Message

Max - 27 Oct 2006 07:06 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Reply to this Message

shiva - 27 Oct 2006 09:01 GMT

Thanks.Your solution worked perfectly.

> To retain it as number, pre-format the col as Custom, Type: 000
>
[quoted text clipped - 6 lines]
> > and remains only 65)So if anyone know the way to solve this problem please
> > help.

Reply to this Message

Max - 27 Oct 2006 10:29 GMT

Shiva, you're welcome !

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Thanks. Your solution worked perfectly.

Reply to this Message