Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell formatting
I inherited a large spreadsheet at work/ when I format a column of cells as
Special/Zip Code the result is returning two decimal places 890.15 / I Clear the formatting but it still returns two decimal places/ is there a master setting that calculates all entries on entry with decimal places ? ; if so how does one reset it so there are no decimal places ? |
#2
|
|||
|
|||
Try:
Tools Options Edit clear the Fixed decimal checkbox. -- Gary''s Student "Martins" wrote: I inherited a large spreadsheet at work/ when I format a column of cells as Special/Zip Code the result is returning two decimal places 890.15 / I Clear the formatting but it still returns two decimal places/ is there a master setting that calculates all entries on entry with decimal places ? ; if so how does one reset it so there are no decimal places ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting a full row triggered by a single cell reference... | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Cell Formatting | Excel Discussion (Misc queries) |