I've used Excel in a superficial way for years - mostly for financial tasks. If I define the Format of a range of calculated cells as Numeric with 2 decimals [ being monetary ] why does SUM give me a Total of the calculated values, not the sum of values displayed as I have specified ? I trawled the Help and tried TRUNCATE but got nowhere.
Bookmarks