Cell formatting when importing data

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

Guest

When I import data from a delimited file into Excel 2000, even though I have
pre-formatted a column as text, entries such as 12-5 and 1-4 -- which are not
dates display as dates. When I reapply the text formatting I get a number:
38691. How can I get 12-5 to display as is when I bring the data in?
 
Rename the file to *.txt and use the text import wizard, just click next
twice and in step 3 select text from column data format for this particular
column and click finish
 
Thanks, worked like a charm.


Peo Sjoblom said:
Rename the file to *.txt and use the text import wizard, just click next
twice and in step 3 select text from column data format for this particular
column and click finish
Click to expand...
 

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

Cell not calculating after importing data 2
CSV->Excel Data Problem 1
CSV imported data being formatted as a date 2
Why this paste result? 4
change the display data format cell already contain data as date 2
retain custom date format "text" when pasting or reformatting data 2
Data being corrupted by excels automatic date recognition re-forma 6
Date conversion on text file import 5

Back
Top