Formatting Decimal points

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sizemorem - 30 Sep 2006 06:37 GMT

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 to this Message

Niek Otten - 30 Sep 2006 08:49 GMT

Tools>Options, Edit tab, check Fixed decimal

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|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 to this Message

Gord Dibben - 30 Sep 2006 16:15 GMT

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

>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 to this Message