Excel date conversion

Тәжірибелік нұсқаулар және стиль

This shows 2 ways of converting an incorrect date format into a format Excel can recognize and use in formulas.

Пікірлер: 10

  • @warrenfield7530
    @warrenfield753017 күн бұрын

    Thanks - clear, to the point advice that works

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

    THANKS FOR SHARING ...I WASTED SO MUCH TIME TO LEARN THIS....BUT YOU DID IT WITHIN NO TIME.....THANK YOU

  • @jaipalrana.
    @jaipalrana.6 жыл бұрын

    This is superb example for anyone who is looking to convert date at its own choice!!!!!

  • @ranib.el-ayoubi6323
    @ranib.el-ayoubi63234 ай бұрын

    thank you! very much for the quickest help 🤩

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

    How do you convert series of numbers into date? For example I have 1231206 and want to convert it to 12/06/23? So there is the 1 extra in front of yymmdd...is there a simple formula to convert that into a date? Thanks

  • @varundagar8634
    @varundagar86346 жыл бұрын

    thanks really informative !!

  • @soumiamoujane3695
    @soumiamoujane36952 жыл бұрын

    What is the format for day, date, Month, year?. Without my cell box,

  • @fishregulator
    @fishregulator5 ай бұрын

    just saved my job 😂

  • @lestercantem7740
    @lestercantem77403 ай бұрын

    Thank you very much for helping me out for my tax returns!

Келесі