Hi all,

I am working with a spreadsheet of archived baseball team rosters (each year’s roster is contained as one sheet in the larger workbook).  These were previously on paper, but are now being digitized.

The problem we are running into is with player heights (i.e. feet and inches).  As you can see in the example screenshot below, heights have been typed in feet-inches format; for example the first player has a height of 5 feet, 11 inches.

However, Excel is formatting these as dates rather than heights (i.e. the first player is showing May 11 rather than simply 5-11).  Although the values read correctly in this spreadsheet, it presents an issue when we ingest this data into our website, which is expecting heights in #-# format with feet and inches.  Instead, for the first player the website is receiving 5/11/2023 and so on.  Because of this the website disregards the height column for most players.  The exception is anyone whose height doesn’t conflict with a date, for example 6 feet even (6-0).

If I change the column category to either General or Text, the values change to a random string of numbers.

Given that we have about 40 seasons worth of player rosters in this workbook, is there an efficient process that we could take this data and put it into a format suitable for importing (such as a simple 5-11, 6-3, etc)?

Thanks in advance for any insight, and happy to share additional context/details if needed.

​Hi all, I am working with a spreadsheet of archived baseball team rosters (each year’s roster is contained as one sheet in the larger workbook).  These were previously on paper, but are now being digitized. The problem we are running into is with player heights (i.e. feet and inches).  As you can see in the example screenshot below, heights have been typed in feet-inches format; for example the first player has a height of 5 feet, 11 inches. However, Excel is formatting these as dates rather than heights (i.e. the first player is showing May 11 rather than simply 5-11).  Although the values read correctly in this spreadsheet, it presents an issue when we ingest this data into our website, which is expecting heights in #-# format with feet and inches.  Instead, for the first player the website is receiving 5/11/2023 and so on.  Because of this the website disregards the height column for most players.  The exception is anyone whose height doesn’t conflict with a date, for example 6 feet even (6-0).  If I change the column category to either General or Text, the values change to a random string of numbers. Given that we have about 40 seasons worth of player rosters in this workbook, is there an efficient process that we could take this data and put it into a format suitable for importing (such as a simple 5-11, 6-3, etc)? Thanks in advance for any insight, and happy to share additional context/details if needed.  Read More

​