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