Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Telephone number format | Excel Discussion (Misc queries) | |||
Format decimal controls do not work | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |