| 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) | |||
Hybrid Mode
