Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Yesterday i work on numerous spreadsheets. I used the format "Accounting"
zero decimal places on the numbers. Today when I opened up these worksheets all formats have been changed to "Custom". When I try to change it back to Accounting with no decimal places it brings back the message "Enter A Different Value" Your entry cannot be used. Try entering an interger or decimal number. What caused this? How do I change them back to Accounting with no decimal places? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) | |||
Automatic formatting problem in Excel | Excel Worksheet Functions | |||
Count and Sum with Conditional Formatting Problem | Excel Worksheet Functions | |||
problem with formatting cell to date format | Excel Worksheet Functions | |||
Formatting Cell problem | Excel Discussion (Misc queries) |