How to Format Baseball Heights as Feet and Inches in Excel
Question details
The user needs to enter baseball player heights (e.g., 5-11, 6-3) into a spreadsheet without the software automatically converting these values into dates.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Importing or manually entering historical baseball rosters to save as XLS or CSV files for website upload.
- Observed behavior
- When hyphenated height values like 5-11 are entered, Excel automatically interprets and formats them as dates (e.g., May 11) instead of preserving the feet-and-inches format.
Determine whether you only need to display the heights as text on a website, or if you plan to sort, rank, or average the heights. This will dictate whether you should use text formatting or numerical values.
Pre-format the Column as Text
This is the best method when entering or pasting new roster data that is intended for display only.
By formatting the cells as Text before entering any data, you instruct Excel to treat whatever you type exactly as a text string, completely bypassing the automatic date conversion feature.
Click the column header letter (e.g., Column C) to highlight the entire column where you plan to enter the player heights.
Right-click the highlighted column and select "Format Cells" from the context menu, or navigate to the Home tab.
In the Format Cells dialog under the Number tab, select "Text" from the Category list and click OK.
Begin entering your values (such as 5-11 or 6-3). Excel will now preserve the exact hyphenated format without changing it to a date.

Use an Apostrophe Prefix for Manual Entry
A quick workaround for manual data entry without needing to change the overall column formatting.
Store Total Inches or Use Separate Columns
Essential if you need to perform calculations, sort, or rank the roster by height.
Easily Format and Manage Rosters with WPS Spreadsheet
WPS Spreadsheet provides powerful and intuitive cell formatting tools that easily prevent unwanted date conversions. It fully supports standard CSV and XLS exports, making historical roster management completely hassle-free.
- 1. Open Your File: Launch WPS Spreadsheet and open your downloaded Google Sheets file or start a blank workbook.
- 2. Select the Height Column: Click the column letter to select all cells where heights will be inputted.
- 3. Change Format to Text: Go to the Home tab, click the Number Format dropdown, and select "Text".
- 4. Save and Export: Enter your 5-11 values, then go to Menu > Save As to export the file seamlessly as an XLS or CSV for your website.

Frequently Asked Questions
Why does Excel change 5-11 to May 11 automatically?
Excel has a built-in feature designed to speed up date data entry. When it detects numbers separated by hyphens (-) or slashes (/), it assumes you are typing a date and automatically converts it. While helpful for accounting, this disrupts fractions, part numbers, and heights.
Can I fix heights that have already been converted to dates?
Unfortunately, once Excel converts a text entry into a date, the original text is replaced by a date serial number. Changing the format back to Text will only show a 5-digit number (like 44327). You will need to format the column as Text first, and then re-enter the data.
Will formatting as Text affect exporting my roster to a CSV file?
No. In fact, formatting as Text ensures your CSV file is accurate. When you save as CSV, the file stores the raw text exactly as it looks (e.g., 5-11). However, be careful if you re-open that CSV file in Excel later, as Excel will attempt to convert those text values into dates again unless you use the Data Import Wizard.




