Formatting a Imported Table

[Joe Galvan]

Hi everyone,

I am importing a table from an outside data source into Excel 2010...

The date gets pulled in as 12910, in actuality it is 1/29/10...

I format the date, using the text to columns function... because using just the regular date formatting tool, reads the 12910 as a date address and returns 5/6/1935, which is incorrect.


The text to columns tool works fine, but when I Refresh the table, the formatted date goes crazy and returns funky looking dates?

Is there any way that an imported table can hold a date format, even through a refresh?


thanks agani,
JOE