Formating advanced numbers

[Negreiros]

How do I input a value 1.20 and keep it on 1.20 instead of 1.2 in excel? In
other words, i want a number like #.##000 or either #.#00 and keeping the
original "0" digits as typed. Not by changing the "Regional Options" in
control pannel...

[Zone]

Select cell(s) to be formatted. Then select Format from the menubar,
then Cells, then on the Number tab, 2 decimal places. James
Negreiros wrote:
> How do I input a value 1.20 and keep it on 1.20 instead of 1.2 in excel? In
> other words, i want a number like #.##000 or either #.#00 and keeping the
> original "0" digits as typed. Not by changing the "Regional Options" in
> control pannel...

[Gary''s Student]

Format > Cells.. > Number > Number and set Decimal Places to two
--
Gary''s Student


"Negreiros" wrote:

> How do I input a value 1.20 and keep it on 1.20 instead of 1.2 in excel? In
> other words, i want a number like #.##000 or either #.#00 and keeping the
> original "0" digits as typed. Not by changing the "Regional Options" in
> control pannel...