Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
defined cell as currency but still have to enter decimal point
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
defined cell as currency but still have to enter decimal point
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop next cell being selected on Enter | Excel Discussion (Misc queries) | |||
Stop next cell being selected on Enter | Excel Discussion (Misc queries) | |||
Display a digit before or after the decimal point in another cell | Excel Worksheet Functions | |||
How do I enter a decimal automatically without typing it every ti. | New Users to Excel | |||
decimal point override does not work | Excel Discussion (Misc queries) |