Formatting Decimal points sizemorem 30.09.2006 05:37:01 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

Re: Formatting Decimal points "Niek Otten" <nicolaus[ at ]xs4all.nl> 30.09.2006 07:49:33 Tools>Options, Edit tab, check Fixed decimal -- Kind regards, Niek Otten Microsoft MVP - Excel "sizemorem" <sizemorem[ at ]discussions.microsoft.com> wrote in message news:4288DA85-30CB-4979-9E8C-978B2AECF676[ at ]microsoft.com... |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

Re: Formatting Decimal points Gord Dibben <gorddibbATshawDOTca> 30.09.2006 15:15:01 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 <sizemorem[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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