Fix ####,
on channel: AuditExcel Advanced Excel and Financial Model Training and Consulting
The best way in Excel to correct dates that give you a #VALUE error, or format to ########, don't sort, format or allow calculations. Using the Convert Text to Column tool you can easily correct thousands of dates.
------------------------------------------------------------------------------------------------------------------------------------------------------
✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Fix Excel dates issues- Text to Column (most recommended)
00:23 Fix dd/mm/yyyy from/ to mm/dd/yyyy issues
00:30 Test if Excel recognizes a date
00:38 Use Text to column and tell Excel what type of date you have received
01:30 Fix dates shown as ddmmyyyy or mmddyyyy (no separator) and the #### date issue
02:57 Correct dates shown as dd.mm.yyyy or mm.dd.yyyy (SAP issue?)
Watch video Fix ####, online without registration, duration hours minute second in high quality. This video was added by user AuditExcel Advanced Excel and Financial Model Training and Consulting 22 July 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 10,553 once and liked it 30 people.