Accounting Format

T

Tom

Is there a format for putting two decimal places in a number automatically, like when your using an accounting calculator. Ie: if you enter 45 you would get .45 and if you entered 145 you would get 1.45 Please help!
 
N

Norman Harker

Hi Tom!

Use:
Tools > Options > Edit
Fixed Decimal places
Set at 2
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top