Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel assumes too much
Hi There,
I have a procedure that imports a .csv file. All was going well until some of the cell values being imported were 17DEC, 28DEC and that made Excel think they are dates and puts into the cell 17-Dec & 28-Dec, which is wrong, these are actually stock codes. How do I make sure that when I am processing the data that it stays exactly as it is in the .Csv file. Do I have to format the column to be Text before hand? When I tried that it changed 17DEC into something like 38334 Any help or advice would be appreciated. Best Regards, Steve Wilson. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weekly bar charts assumes i mean daily bar chart | Charts and Charting in Excel | |||
cell assumes wrong date | Setting up and Configuration of Excel |