Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Decimal points
I want to do a custom number format that will automatically mark off two
decimal places just like my adding machine does. Ex: type 12345 entry becomes $123.45 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Decimal points
ToolsOptions, Edit tab, check Fixed decimal
-- Kind regards, Niek Otten Microsoft MVP - Excel "sizemorem" wrote in message ... |I want to do a custom number format that will automatically mark off two | decimal places just like my adding machine does. | | Ex: type 12345 entry becomes $123.45 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Decimal points
There is no Custom Format to do what you want.
You can follow Niek's suggestion for FDP but be aware that this is a global setting and will affect all workbooks. If you don't want the 123.45 in a cell enter it as 12345. to override the FDP There are other methods that would involve VBA Gord Dibben MS Excel MVP On Fri, 29 Sep 2006 22:37:01 -0700, sizemorem wrote: I want to do a custom number format that will automatically mark off two decimal places just like my adding machine does. Ex: type 12345 entry becomes $123.45 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can this be done using an array formula ? | Excel Worksheet Functions | |||
hlookup function | Excel Worksheet Functions | |||
Aligning Decimal Points with non-numeric data | Excel Discussion (Misc queries) | |||
why 2003 excell does not accept dot as decimal points | Excel Discussion (Misc queries) | |||
Leading Zeros and decimal points | Excel Worksheet Functions |