Thank you. Sorry, it took me some time to check on these files. I noticed that the first file you attached has the extension .txt
An excel file is supposed to have the extension .xls or .xlsx.
- I opened the attached file you sent by just opening it directly and it opened in the Notepad program and it looks like in the image below:
- I opened your attached file in the older Excel version 2003 and it looks like below after increasing the columns widths of the dates in order to avoid seeing ######...:
- I opened your attached file in the Excel version 2010 and it looks like below after increasing the columns widths of the dates in order to avoid seeing ######...:
- If you do not adjust the column widths of the dates, it will show incorrectly like in the image below:
The 2nd file you attached is in the correct Excel format. I opened in both Excel 2003, and 2010, they look the same.
It looks the same on both Excel versions. But you should adjust the widths of the columns first to show all content. Then it will show fine in all versions of Excel.
Where do you see weird formats?
When you are available, please reply back at the box below to continue. Thank you,