format for curanncy without typing decimal
 

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?

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

Aln54 wrote:

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?

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

"garfield-n-odie" wrote:

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

Aln54 wrote:

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?

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

Aln54 wrote:

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

"garfield-n-odie" wrote:


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

Aln54 wrote:


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?