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.
I can't seem to figure this one out...
I'd like to convert a number series, (no separators), to a date. Right now, I have, for example, 20221110, (YYYYMMDD). How do I quickly convert this to a usable date, 11/10/2022? I have a whole column of dates like this, so I need some sort of formula or shortcut, in order to convert this efficiently.
Any help is much appreciated. Thank you!
MacBook Pro 13″, OS X 10.11
Here is one option, you would need an additional column for the new date
B3= DATE(LEFT(A3,4),MID(A3,5,2),RIGHT(A3,2))
It is using the date function to create a proper date based on the given values.
Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.
Hope this will solve your question, please let me know if this worked for you or if something in unclear.
Regards Ralf
Here is one option, you would need an additional column for the new date
B3= DATE(LEFT(A3,4),MID(A3,5,2),RIGHT(A3,2))
It is using the date function to create a proper date based on the given values.
Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.
Hope this will solve your question, please let me know if this worked for you or if something in unclear.
Regards Ralf
Ralf, you're a genius! ;-)
It worked perfectly! You saved me a lot of time.
Thank you so much.
Best,
warbles
Mac Numbers: Convert numbers to date
