Use Text to Columns Convert Dates Stored as Text
19.1 هزار بار بازدید -
6 سال پیش
-
Have you ever gotten a
Have you ever gotten a file and it there was a column that represented a date, but when you tried to perform some calculation with the value in the date column you get some error like a #VALUE? It's most likely due to the fact that the values in that column are text representation of the date (i.e., Monday February 19 2018 6:28 PM). Excel will recognized this as text and one indication is to see if it is left aligned to the cell (values/numbers are right aligned to the cell). If you wanted to do date calculation you'd need to convert the date text into a "proper" date value. This video shows how to use the Text to Columns feature to do that so check it out!
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
Convert Table in a PDF File to Excel
~-~~-~~~-~~-~
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
Please watch: "Convert Table in a PDF File to Excel"
Convert Table in a PDF File to Excel
6 سال پیش
در تاریخ 1397/04/26 منتشر شده
است.
19,173
بـار بازدید شده