G Guest Dec 30, 2004 #1 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?
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 Dec 30, 2004 #2 In Excel, click on Tools | Options | Edit | check the "Fixed decimal places" box and set the number of decimal places to 2 | OK.
In Excel, click on Tools | Options | Edit | check the "Fixed decimal places" box and set the number of decimal places to 2 | OK.
G Guest Dec 30, 2004 #3 Thank you very much!!! I just needed someone that didn't have a senior memory!! Thanks Again. Al
G garfield-n-odie Dec 30, 2004 #4 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 : Click to expand...
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 : Click to expand...