defined cell as currency but still have to enter decimal point
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.
"Ron Coderre" wrote:
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
"Beebs" wrote:
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?
|