changing the format of cells?
I have already formatted cells within numbers but when I try to change the format of a cell it keeps reverting the the previous format. How do I make it stay on the new format?
MacBook, OS X Yosemite (10.10.5), Numbers
I have already formatted cells within numbers but when I try to change the format of a cell it keeps reverting the the previous format. How do I make it stay on the new format?
MacBook, OS X Yosemite (10.10.5), Numbers
Does the cell that reverts to the previous format contain a formula? If so it could be that one or more of the cells to which that formula refers are a specific type (for example duration) and that therefore the format to which you are trying to change doesn't make sense to Numbers. Could you give more specifics?
SG
Thanks for your reply. Yes it does contain formulas. I have done these sorts of calculations on Excell and OpenOfficeCalc and this does not cause any problems. This spreadsheet is calculating hours worked and multiplying them by pay rate to get wages. It needs to do calculations involving duration, pay rates, overtime rates, and produce an answer in dollars. Is there a way of disabling this error so that Numbers will work like other spreadsheets?
Numbers handles duration/time differently from Excel and other spreadsheets. The Numbers approach can be very convenient, but also can be confusing when you first encounter it. You can use the DUR2HOURS function (and its cousins) to convert a duration to decimal hours that can be formatted as a number and/or used in further calculations. You can learn more about this by going (in your menu) to Formulas and Functions Help and searching for DUR.
If you need more specific help, perhaps you could post a screenshot.
BTW, suggest having a look at the 'Employee Schedule' template in the 'Business' section at File > New in your menu.
SG
changing the format of cells?