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