| 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? |
| 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) | |||
Threaded Mode
