Formatting Issues

How to Format Baseball Heights as Feet and Inches in Excel

Steven ParkerSteven Parker Nov 11, 2026 868 views

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.

How to Format Baseball Heights as Feet and Inches in Excel Without Date Conversion
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the Target Column

Click the column header letter (e.g., Column C) to highlight the entire column where you plan to enter the player heights.

2
Open Format Cells

Right-click the highlighted column and select "Format Cells" from the context menu, or navigate to the Home tab.

3
Apply Text Format

In the Format Cells dialog under the Number tab, select "Text" from the Category list and click OK.

4
Enter the Height Data

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.

Pre-format the Column as Text
Important Timing: You must apply the Text format before typing the data. Formatting a cell as Text after it has already been converted to a date will only show the underlying date serial number (e.g., 44327).
Seamless Spreadsheet Formatting

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. 1. Open Your File: Launch WPS Spreadsheet and open your downloaded Google Sheets file or start a blank workbook.
  2. 2. Select the Height Column: Click the column letter to select all cells where heights will be inputted.
  3. 3. Change Format to Text: Go to the Home tab, click the Number Format dropdown, and select "Text".
  4. 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.
Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csvEasy-to-use text formatting to prevent automatic date conversionLightweight, fast, and completely free for standard data entry tasks
microsoft office alternative - wps office

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.