Fix ####,
на канале: 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?)
