You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
How do i convert the date information in a csv file which comes in as yyyymmdd i.e. 20201121 in Numbers.?
I would like to format it as November 21, 2020.
Do i have to format it as 2020/11/21 and then format it to November 21, 2020?
You'd have to write a calculation that takes the number and formats it as a date.
For example...
DATE(LEFT(Cell Reference,4),MID(Cell Reference,5,2),RIGHT(Cell Reference,2))
...replacing "Cell Reference" with the cell that has the number in it.
At that point, you can format the cell with the date calculation to display however you want.
You'd have to write a calculation that takes the number and formats it as a date.
For example...
DATE(LEFT(Cell Reference,4),MID(Cell Reference,5,2),RIGHT(Cell Reference,2))
...replacing "Cell Reference" with the cell that has the number in it.
At that point, you can format the cell with the date calculation to display however you want.
Thank you for that solution
Numbers on Mac - format number to date
