numbers default to date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.


QA said:
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
Click to expand...
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?
 
Back
Top