In Apple Numbers the app can work out the number of days between dates, but then if I times this by a number (ie, a %interest rate and an amount of money) Numbers insists that the answer is a number of days! Even if I go to Cell>Date Format and change it. The system ignores this and returns to displaying the answer as a number of days. How do I force the system to show this cell as a number and not in the date / days format?
Apple Numbers: how to change a date format to a number format
numbers
Related Solutions
You do not change it in Numbers.
You change the the system date format from the Language & input system Prefpane. Change the Region to United Kingdom.
Next time you launch Numbers the format will be as you want.
You can use the Custmize buttons to set the look of the dates
I believe Insert > Date & Time (and its two companions) are intended for use in headers and footers. These are available after choosing File > Print. When used there, the inserted date can be clicked for a little popup formatter and button to manually reset the time to now.
The feature you want, an auto-generated NOW cell that does not change, is apparently not available.
Option A: Put the NOW function into a cell somewhere. It shows the current time. Copy the cell, then Edit > Paste Formula Results into the cell you want to have the unchanging time.
Option B: Use a general macro app (like the amazingly capable Keyboard Maestro) to generate your date/time text and paste it into a cell.
In both cases, choose the date and time formats you want on the final cell.
(Numbers 3.5.3 used for this answer)
Related Question
- Numbers: how to create a column with a sequence of times
- Mac – How to add the function to change the colour of a cell on numbers after a certain date has been passed
- Change date format for column of existing non-US format datetimes in Numbers
- How to convert US-format date and time into a date value so I can use the local date format
- MacOS – Apple Numbers use Actual date instead of formatted date
Best Answer
You can use a function to convert the duration to a plain number. For example, if difference between the dates in in E4, and it's 10 days, then...
Shows a number, 24.0. There are other functions that you might use:
DUR2DAYS, etc.