I recently updated Numbers to 3.2.
I want to be able to put a date in a cell numerically (8-22-14) and then have it show up with the month name, day, and year (August 22, 2014) without having to do a formula. I do not need the time.
Change date format in Numbers 3.2
numbers
Related Solutions
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)
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...
=DUR2HOURS(E4) × 0.1
Shows a number, 24.0. There are other functions that you might use: DUR2DAYS, etc.
Related Question
- Total per month of daily values
- Can Numbers use 8 hour long days when converting from days to hours
- In Numbers can you auto-populate a cell with a date when another cell is populated
- Change date format for column of existing non-US format datetimes in Numbers
- How to add all of the text strings in all of the cells in a row together
- How to add a calendar month to a date
- MacOS – Apple Numbers use Actual date instead of formatted date
Best Answer
You should be able to enter a date in these newly formatted cells any format (like 8-22-14) and it should change to your selected format.