format for curanncy without typing decimal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Thank you very much!!! I just needed someone that didn't have a senior memory!!
Thanks Again. Al
 
Back
Top