smythcounty
New Member
- Joined
- Jul 29, 2021
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
When I export a CSV file from a third party it puts the times in a weird format. For example, the correct time should be 5:48 AM. If I open the CSV file in notepad the time value = 48:55.6. If I open the CSV file in Excel it shows 48:55.6 and when I select the cell is shows the time value as 12:48:56. AM. If I export into Tabular format I get 05:48:55.5640000. If I export the file into Excel form, its shows the correct time of 5:48 AM. I need it in CSV because this is how I import it with my macro. Any ideas to correct this, or is this a glitch in the exporting program?
Thank You!
Thank You!