Microsoft Excel | Convert Number to a Date Format

Occasionally we get data downloads where dates have been formatted into numbers. When you try to change to a date format, you might see ######## in your cells. Use this method with Data, Text to Columns to format correctly.
Dawn's Microsoft Excel Playlist: • Excelling at Microsoft...
PLEASE SUBSCRIBE for more tips!
🔔 Subscribe for Updates 🔔
TH-cam: / dawnmonroetraining
News Opt-In: learn.dawnmonr...
❤️ Connect on Social ❤️
LinkedIn: / dawnmonroetraining
Facebook: / dawnmonroe.training
Instagram: / dmonroetrain
💥 View Learning Opportunities💥
Calendar: learn.dawnmonr...
This video was recorded with Loom.
#excelformatting #excel #microsoftexcel

[@kellyirving2045]

Life saver! I had over 2,000 entries and didn't want to manually change the dates

[@NB-cx2fw]

, I almost give up then I found this , thank you ❤

[@ExplorewithTaj]

Thanks Dawn you are life saver saved my too much time stay blessed

[@doitdroidgiggle297]

Thank you very much for sharing!!!! You help me a lot!!!!!

[@gayatribora7632]

Thank you so much 🙏🙏
❤from India

[@elizabethm1913]

Thank you! Thank you! 👍

[@deepanshirathore5542]

I was dying finding for this video,but this is so helpful thank you

[@traderphil8180]

Thanks. I was going round in circles until I found your video. Super helpful.

[@asifccie]

Excellent Shortcut, I thought it would take me hours to sort out the data but after watching this video, i finish it in minutes. Really Thanks

[@pratikjoshi5937]

Thanks ma'am

[@MarleeWarner-dg6pm]

Thank you so much, watched 2 other videos before finding yours!

[@satrah101]

I've been at this for hours. Thank you so much.

[@DauterProductions]

This worked for me, thank you so much!

[@mateusznikratowicz4229]

Great, that's what I was looking for :)

[@shahriarislam3238]

Thank u so much dear ..... It helps me a lot.

[@jlach100]

thank you!
How would you calculate CURRENT AGE from that?

[@DawnMonroeTraining]

@jlach100 =(TODAY()-BDayCell)/365 😊😊

[@vikaskamathe9633]

Superb

[@edgarvelez2960]

Hi I have quite the opposite, I have what you have in column B and need to convert it to what you have in column A and help please.

[@DawnMonroeTraining]

@edgarvelez2960 I answer your question in this video: th-cam.com/video/2TH3RckhtlE/w-d-xo.html