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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Number to Text for Index/Match 1
How to subtract a number from a Mergefield? 0
Formatting cells to show two dates in one cell 3
Help? with extracting unsorted data from a worksheet, no blank lin 4
Reference the same cell based on tab name 1
worksheet sorting and linking? 0
Analyze with excel (change access date format) 4
Dates 3

Back
Top