Formatting Issues

How to Stop Excel from Converting Values Like 3:61 to Time Formatting

Algirdas Jasaitis Oct 19, 2026 869 views

Question details

The user needs to input ratio-like or number-colon-number values (e.g., 3:61) without the spreadsheet automatically converting them into time formats.

How to Stop Excel from Converting Values Like 3:61 to Time

Product: Excel
Device & OS: not provided
Scenario: Entering values containing colons (like 3:1 or 3:61) into a spreadsheet cell.
Observed behavior: The spreadsheet automatically interprets and reformats the entries as time values or calculates them, rather than displaying the exact text entered.

Before you start

Select the specific cells, columns, or rows where you plan to enter these values before applying any new formatting rules to ensure the changes take effect correctly.

Solution 1Recommended

Format Cells as Text Before Typing

Changing the cell format to Text beforehand is the most reliable way to ensure any entered data is displayed exactly as typed.

By default, Excel uses a General format that tries to guess the data type. Pre-formatting cells as Text turns off this guessing mechanism.

Select the target cells

Highlight the specific cells, rows, or columns where you will input the values.

Open Format Cells

Right-click the highlighted area and choose "Format Cells" from the context menu, or press the keyboard shortcut Ctrl+1.

Apply Text format

In the Number tab, select "Text" from the Category list on the left side, then click OK.

Enter your data

Type your values (e.g., 3:61). They will now remain exactly as you type them without converting to time.

Format First: Always apply the Text format before typing your data. Applying it after Excel has already converted the value to time will result in a decimal number instead of your original text.

Solution 2

Use an Apostrophe Prefix

A quick workaround for entering a few isolated values without changing the overall cell formatting.

Manage Data Formatting Effortlessly

Use WPS Spreadsheet to Prevent Unwanted Automatic Formatting

WPS Office provides a powerful, free alternative to Microsoft Office. WPS Spreadsheet allows you to easily format cells as text to stop unwanted automatic time conversions, ensuring your data is recorded exactly as intended.

1. Open WPS Spreadsheet: Launch WPS Office and open your document in the Spreadsheet application.
2. Highlight cells: Select the cells you wish to input ratios or specific colon-separated text into.
3. Format as Text: Right-click, select "Format Cells," and choose "Text" under the Number tab.
4. Input accurately: Type your entries like 3:61, and they will stay exactly as written without time conversion.

Easily disable automatic formatting and treat numbers as plain text.Highly compatible with Microsoft Excel (.xlsx and .xls) formats.Lightweight, fast-loading, and completely free to use.Familiar ribbon interface ensures a smooth transition with zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel change 3:61 to a time or different number?

Spreadsheets are programmed to automatically recognize patterns like numbers separated by a colon as time (hours and minutes). If the minutes exceed 59, it may calculate and roll it over to the next hour or display a different value entirely.

Can I remove the time formatting if Excel already converted my data?

If the data was already converted, changing the format back to Text will usually display a decimal number representing the underlying time value. You will need to change the cell format to Text first, and then manually retype the original values.

Does the apostrophe prefix print or export in my documents?

No, the leading apostrophe is only a background indicator telling the software to treat the cell's contents as text. It remains hidden in the actual spreadsheet view and will not appear when printed or exported to PDF.

Document & File Issues