Formatting External Data from Web

JTL9161

Active Member
Joined
Aug 29, 2012
Messages
342
I know this is a formatting issue but wanted to know if there is a work around.

I import daily a couple of web pages with various data that is working fine for me. The only issue I am having is one of the fields which could on the web page for example be a 6-4 7-2...etc. Those fields come over the Excel as dates thus 4-Jun and 7-2 comes over a 7-Feb.

I try to format the text after its imported but it will not go back to the 6-4 or 7-2 format. Is there something I can do within the importing process to make these field come in as text and not dates?


Thanks for your help
James
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

philwojo

Well-known Member
Joined
May 10, 2013
Messages
533
I'm no expert on this, but if you are importing via the 'DATA' tab on the ribbon and then using "From Text" if you walk through the process of say using "Delimited" on the 3rd and final step select the one column that has those values and change it from "general" formatting to "TEXT" and I think that should correct the issue.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,973
Messages
5,525,986
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top