Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi folks,
I am importing the NFL standings into a worksheet - http://www.nfl.com/standings . In the Home, Road, AFC, NFC & DIV columns, the team records are showing up as dates. Example, the Colts record on the NFL site is showing up as: Team W L T PCT PF PA Home Road AFC NFC DIV Streak *yz-Indianapolis 13 1 0 .929 409 206 6-1 7-0 11-1 2-0 6-0 Lost 1 In my workbook, it's showing up as: Team W L T PCT PF PA Home Road AFC NFC DIV Streak *yz-Indianapolis 13 1 0 0.929 409 206 6/1 7/1 11/1 2/1 6/1 Lost 1 I've tried a number of different custom formatting options with no success. Any advice would be appreciated |