| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel 2003 not recognizing whole dollar amounts, formats amt as ce
In my earlier version of Excel, (Office 97), I could format the cells to
automatically enter amounts as dollars and cents. For example, I would type 30. and the amount was shown as $30.00. Or, I could type 4357, and the amount was shown as $43.57. In the Office 2003 version if I type 30., the amount is reflected in the cell as 30 cents instead of $30.00. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 and Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 locks up after startup | Excel Discussion (Misc queries) | |||
| Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
| Problems using Excel 2000 to open/save file saved in Excel 2003 | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
