| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto decimal in currency
how do i get a result value of 12.34 if i input 1234 ?
I work with a large amount of currency values and I dont want to have to type in the decimal each time. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto decimal in currency
ToolsOptionsEdit.
Check "Fixed Decimal Places" and set to 2 using spinner. Note: this is an Excel global setting and will affect all workbooks. Gord Dibben MS Excel MVP On Tue, 23 Oct 2007 20:52:00 -0700, mike6342 wrote: how do i get a result value of 12.34 if i input 1234 ? I work with a large amount of currency values and I dont want to have to type in the decimal each time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to auto-increase values in currency formatted cells, by 10%. | Excel Worksheet Functions | |||
| How to auto-increase values in currency formatted cells, by 10%. | Excel Worksheet Functions | |||
| numbers (currency) don't line up on decimal | Excel Discussion (Misc queries) | |||
| simple currency addition in cell without having to enter decimal | Excel Worksheet Functions | |||
| defined cell as currency but still have to enter decimal point | Excel Worksheet Functions | |||
Linear Mode
