format for curanncy without typing decimal

A

Aln54

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?
 
G

garfield-n-odie

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

Aln54

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