Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing to two place decimal
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing to two place decimal
Hi Debbie,
Only accountants are happy with this choice Tools, Options, Edit, Fixed decimal places: 2 after which you will notice the word FIX in the last box on the Status Bar http://www.mvps.org/dmcritchie/excel/statusbar.htm and I understand that Excel 2003 does not allow you to override by typing a period if you want a whole dollar amount. without typing 00 Actually there are many requests for turning off the option that people don't know about or how it got turned on. It is fairly sneaking because you may go for several hours after changing it to notice the effects. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Debbie" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extra 1 showing up in 15th decimal place | Excel Discussion (Misc queries) | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
Changing default decimal places | Excel Discussion (Misc queries) | |||
excel validation to 1 decimal place | New Users to Excel | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions |