..

hi all,


i'm trying to show "0" in a cell with successor as any other number.

i don want to convert the cell as text, or to add a hyphen before 0,
like " '05 ".

Please let me know how to solve this.


Regards,
Divy

how many digits in the numbers you want to precede with a zero?

go to format cells, choose custom, enter 0### if you want up to 3 digit numbers
to be preceded by a zero


--


Gary


"Divy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> .
>
> hi all,
>
>
> i'm trying to show "0" in a cell with successor as any other number.
>
> i don want to convert the cell as text, or to add a hyphen before 0,
> like " '05 ".
>
> Please let me know how to solve this.
>
>
> Regards,
> Divy
>