defined cell as currency but still have to enter decimal point

[Guest]

Is there a way to enter in dollar amounts and have the software assume a two
diget decimal point without having to actually enter in the dec. point. I
have defined the cell as currency and defined 2 dec. positions. Also defined
as accounting with 2 dec. positions. When I enter in 1234 it comes out
1,234.00.
Any help here?

 

[Guest]

Setting the format to Currency only sets the way the numbers are displayed.

Try this additional step:
Tools|Options|Edit tab
Check: Fixed decimal places and set it for 2.

Note: I'm fairly sure that setting will apply to all workbooks, so you may
need to set it back when you're done.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Guest]

Thanks Ron. That did the trick. That was driving me crazy. Not a big user of
Excel but need to now. I greatly appreciate your prompt response. Bless you.