Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP format issues? | Excel Worksheet Functions | |||
Stock Format Issues | Charts and Charting in Excel | |||
.txt format issues | Excel Discussion (Misc queries) | |||
Sumproduct and format issues | Excel Worksheet Functions | |||
Importing a .txt file issues | Excel Discussion (Misc queries) |