| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrong number, no currency format
each time i enter a number in a worksheet such as 5, it shows up as .05.
also, i cannot get my worksheet to format the cells in currency without pressing the $ icon. thank you. -- DaveB |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
wrong number, no currency format
Tools Options Edit tab
Uncheck the Fixed Decimal Places checkbox. HTH Kostis Vezerides On Nov 16, 3:25*pm, dberger16 wrote: each time i enter a number in a worksheet such as 5, it shows up as .05. * also, i cannot get my worksheet to format the cells in currency without pressing the $ icon. * thank you. -- DaveB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between Currency and Accounting number format. | Excel Discussion (Misc queries) | |||
| Wrong number format after exporting from sharepoint list | Excel Discussion (Misc queries) | |||
| Currency format for Excel 2007 not displaying actual number | Excel Discussion (Misc queries) | |||
| How do I format to currency when number includes cents? | Excel Worksheet Functions | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Linear Mode
