Importing CSV format issues
I am importing a CSV file into an Excel 2000 spreadsheet. One of the columns
is a timestamp. I have this column formatted as text in my Excel spreadsheet
and when I few the data in the CSV file using Notepad the timestamp is
indeed text format.
When I import the data from the CSV file into my Excel spreadsheet, the
timestamp comes in as text UNTIL it reaches a 2-digit hour and then the cell
is formatted as Time. Any ideas on why this is occuring and how I can remedy
it.
Thanks,
Barry
|