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 🔔
KZread: / dawnmonroetraining
News Opt-In: learn.dawnmonroetraining.com/...
❤️ Connect on Social ❤️
LinkedIn: / dawnmonroetraining
Facebook: / dawnmonroe.training
Instagram: / dmonroetrain
💥 View Learning Opportunities💥
Calendar: learn.dawnmonroetraining.com/...
This video was recorded with Loom.
#excelformatting #excel #microsoftexcel

Пікірлер: 15

  • @traderphil8180
    @traderphil818023 күн бұрын

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

  • @ExplorewithTaj
    @ExplorewithTaj11 күн бұрын

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

  • @pratikjoshi5937
    @pratikjoshi5937Ай бұрын

    Thanks ma'am

  • @deepanshirathore5542
    @deepanshirathore5542Ай бұрын

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

  • @asifccie
    @asifccie4 ай бұрын

    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

  • @MarleeWarner-dg6pm
    @MarleeWarner-dg6pmАй бұрын

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

  • @satrah101
    @satrah1017 ай бұрын

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

  • @DauterProductions
    @DauterProductions5 ай бұрын

    This worked for me, thank you so much!

  • @mateusznikratowicz4229
    @mateusznikratowicz42292 ай бұрын

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

  • @shahriarislam3238
    @shahriarislam32387 ай бұрын

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

  • @vikaskamathe9633
    @vikaskamathe9633 Жыл бұрын

    Superb

  • @jlach100
    @jlach1005 ай бұрын

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

  • @DawnMonroeTraining

    @DawnMonroeTraining

    5 ай бұрын

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

  • @edgarvelez2960
    @edgarvelez29608 ай бұрын

    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

    @DawnMonroeTraining

    8 ай бұрын

    @edgarvelez2960 I answer your question in this video: kzread.info/dash/bejne/ZIh8lbScm8vanKg.html

Келесі