Imported data changes to date format (5-1-5 changes to May 1, 2005

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

Guest

I am importing data from another program into Excel. One of the fields being
imported is in the format #-#-# and when it gets to Excel it formats it as
Month day year (Ex. 5-1-5 is imported as May 1, 2005). How can I get it to
import into Excel as 5-1-5?
 
I too have a problem with this, but the answer is not as simple as you might think. Whenever I import stat data from a web page I want to copy the data just like it appears into an excel sheet. I don't want to waste time coping cell by cell data, so I highlight the complete table and then copy it. I then open up excel and highlight the entire sheet, then "Paste" not "Paste Special" that data into excel. This works great for just about everything except any data spaced by dashes (i.e."7-3"). Whatever format was previously setup is irrelevant to the excel program, and once it has changed it can no longer be changed back to the way it was! So, if anyone has the solution to this problem that would be great.

Cheers,
Brian


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
You may want to look at using Data|Import External Data|New Web Query.

It may do everything you want with no trouble.
 
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

Which is the best MBOX Converter Tool different formats conversion? 5
Formatting Numbers into Text or???!!! 2
Import data csv file - tab delimited - and sort to column 3
METRO 2039 Revealed 0
How to Export Gmail Emails to PST Format? 5
Formatting with imported data 2
Formatting Numbers to Text or??!!! 6
Importing a Text File Into 1 Column 3

Back
Top