Gord, that did it. Didn't even have to open a new worksheet,. Just opened my
original formatted sheet, right clicked to get "edit query", went into
options and took out that date function and replicated.

Very nice. Again ... Thank you for your current and prior suggestions.

Happy Holidays.

Bob

"Gord Dibben" wrote:

Bob

Formulas cannot format cells.

I managed to get it done directly by-passing the *.txt file.

Insert a new worksheet.

DataImport External DataNew Web Query.

Type or paste in the URL http://www.nfl.com/standings

That site will open and give you yellow arrows to select what you want.

Click on the Options button and checkmark FormattingNone Import<PRE blocks
into columns and Disable Date Recognition.

Hit Import.

Save the workbook with the query and next week just hit DataImport External
DataData Refresh.


Gort