format for curanncy without typing decimal

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aln54 - 30 Dec 2004 21:05 GMT

Is there a way I can format my numbers so when I enter 12345 they will show
as 123.45 without me having to enter the decimal?

Reply to this Message

garfield-n-odie - 30 Dec 2004 21:09 GMT

In Excel, click on Tools | Options | Edit | check the "Fixed decimal
places" box and set the number of decimal places to 2 | OK.

> Is there a way I can format my numbers so when I enter 12345 they will show
> as 123.45 without me having to enter the decimal?

Reply to this Message

Aln54 - 30 Dec 2004 21:27 GMT

Thank you very much!!! I just needed someone that didn't have a senior memory!!
Thanks Again. Al

> In Excel, click on Tools | Options | Edit | check the "Fixed decimal
> places" box and set the number of decimal places to 2 | OK.
>
> > Is there a way I can format my numbers so when I enter 12345 they will show
> > as 123.45 without me having to enter the decimal?

Reply to this Message

garfield-n-odie - 30 Dec 2004 21:35 GMT

you're welcome, and thanks for the feedback :-)

> Thank you very much!!! I just needed someone that didn't have a senior memory!!
> Thanks Again. Al
[quoted text clipped - 4 lines]
>>>Is there a way I can format my numbers so when I enter 12345 they will show
>>>as 123.45 without me having to enter the decimal?

Reply to this Message