If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
numbers default to date
I have data from a company system that I am pasting into a worksheet. The data pulls in like delimited text file so I run it through the Text to Columns actions. The data pulls in with integrity, but when it runs through the column process it changes #-# and #-#-# to a date(I have used the General and the Text selections). The number of columns is not fixed, so I cannot preset one particular column for the number series. Is there any way to stop this from happening?
|
#2
|
|||
|
|||
numbers default to date
Change the file extension from .csv to .txt then when you open
the file the text import wizard will allow you to specify the format for each column. I think you are looking for format such columns as text. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "QA" wrote ... I have data from a company system that I am pasting into a worksheet. The data pulls in like delimited text file so I run it through the Text to Columns actions. The data pulls in with integrity, but when it runs through the column process it changes #-# and #-#-# to a date(I have used the General and the Text selections). The number of columns is not fixed, so I cannot preset one particular column for the number series. Is there any way to stop this from happening? |
Thread Tools | |
Display Modes | |
|
|