| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Changing default decimal places
Is there a way to change the default decimal places for cell formatting. For
example, whenever I use the currency format, it automatically defaults to 2 decimal places. I would like to change that to 0. In tools/options/edit, I already have the fixed decimal places set to O, but that does not seem to work. thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) | |||
| Changing display of decimal value based on the value in the cell | Excel Worksheet Functions | |||
| How do I change the number of decimal places displayed in Excel | Excel Discussion (Misc queries) | |||
| Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
| ROUND DATA TO 2 DECIMAL PLACES | New Users to Excel | |||
Threaded Mode
