Formatting Issues

How to Stop Excel from Converting Decimal Values to Roman Numerals

Adam Davis Oct 8, 2026 870 views

Question details

The user wants to prevent Excel from automatically changing typed decimal numbers into Roman numeral date formats.

How to Stop Excel from Converting Decimal Values to Roman Numerals

Product: Microsoft Excel
Device & OS: not provided
Scenario: Entering decimal values (e.g., 5.12) into a spreadsheet for data tracking.
Observed behavior: Excel auto-formats the entered decimal number into a Roman numeral date representation (e.g., changing 5.12 to 05.XII).

Before you start

Make sure to apply these formatting changes before entering your data. If you format the cells after Excel has already converted the numbers, the original values cannot be restored automatically and must be re-entered manually.

Solution 1Recommended

Pre-format Cells as Text Before Data Entry

This is the most efficient method for entering multiple decimal values without having to use special characters each time.

By changing the cell format to Text before you start typing, you instruct Excel to treat whatever you enter as a static text string, completely bypassing the automatic date conversion algorithm.

Select the target cells

Highlight the specific cell, range of cells, or entire column where you plan to enter your decimal values.

Open the Format Cells dialog

Right-click the highlighted area and select 'Format Cells' from the context menu.

Apply Text formatting

Navigate to the 'Number' tab, select 'Text' from the Category list on the left, and click 'OK'.

Enter your data

Type your decimal values (like 5.12) into the formatted cells. They will now remain exactly as typed.

Pre-format Cells as Text Before Data Entry

Permanent Solution: This method acts as a permanent fix for the selected range, saving you from having to adjust every single entry.

Solution 2

Use an Apostrophe for Individual Entries

Ideal for quick, one-off data entries where you don't want to change the formatting of the entire column.

Effortless Data Management

Prevent Unwanted Number Conversions with WPS Spreadsheet

WPS Spreadsheet provides intuitive cell formatting options that prevent unwanted automatic conversions, ensuring your decimal values remain exactly as you entered them. It is a highly compatible and lightweight solution for all your data entry needs.

1. Open WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
2. Highlight the data range: Select the cells or columns where you intend to input your decimal figures.
3. Access cell formatting: Right-click the selected cells and click 'Format Cells' from the dropdown menu.
4. Set category to Text: Under the 'Number' tab, choose 'Text' from the category list and confirm by clicking 'OK'.
5. Input safely: Type your decimal numbers securely without fear of them changing into Roman numerals or dates.

Fully compatible with Microsoft Excel (.xlsx and .xls) formats.Intuitive and easy-to-use formatting interface to stop auto-conversion.Lightweight application that runs smoothly even on older devices.Free to download and use with a familiar user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel change my decimal numbers to Roman numerals?

Excel has a built-in auto-formatting feature that attempts to interpret certain number combinations as dates. In specific regional settings or custom date formatting modes, a number like 5.12 is interpreted as May 12th, and the month or day might be displayed using Roman numerals (e.g., 05.XII).

Can I still use formulas on numbers formatted as text?

Generally, mathematical functions like SUM or AVERAGE will ignore cells formatted as text. If you need to perform mathematical operations on these numbers, you might need to adjust your computer's regional date settings instead of using text formatting, or convert them back into numbers within your formula using the VALUE function.

How do I fix numbers that have already been converted to Roman numerals?

Unfortunately, once Excel converts the typed decimal into a date/Roman numeral, the original input is overwritten by a date serial number. You must change the cell format back to General or Text, and then manually re-enter the original decimal values.

Is there a setting to turn off automatic date conversion globally?

In recent versions of Microsoft 365, you can disable automatic data conversions globally by navigating to File > Options > Data, and unchecking the options under 'Automatic Data Conversion'. For older versions, pre-formatting as text is the only reliable method.

Document & File Issues