[Solved!] Fraction Changing to Date in Excel (5 Quick Solutions)

Suppose, you are trying to insert fraction numbers in an Excel sheet. But they are automatically changing to dates. You might get really annoyed. But you don’t need to worry about this because you will learn 5 solutions here to stop a fraction from changing to a date in Excel.

Why Fraction Automatically Changes to Date in Excel?

By default the cell format in Excel is General. In this state, when you insert a fraction number inside a cell it automatically changes to date. It’s a feature that helps insert date into cells quite easily.

But when someone actually intended to insert fraction numbers, he might get depressed with this feature.

To demonstrate this, I’m inserting ½ in cell C5.

As I press ENTER, it automatically changes to date.

Now, let’s see how to fix this dilemma.

Stop Fraction Changing to Date in Excel: 5 Solutions

1. Applying Text Format to Stop Fraction Changing to Date

The first thing we can do is a change to cell format from General to Text.

To do that,

❶ Select all the cells first.

❷ Then press CTRL + 1.

Format Cells dialog box will appear.

❸ Select Number ➤ Text.

❹ Then hit OK.

Now if you insert a fraction in the cells, it doesn’t change your fraction to date.

Read More: How to Write a Fraction in Excel 

2. Using Space Before Numbers to Stop Fraction Changing to Date

Inserting a space before numbers can prevent a fraction from changing to date in Excel.

All you need to do is,

❶ Select a cell first.

❷ Then press the Space button to insert a space.

❸ After that insert a fraction number.

❹ Then press ENTER.

Now your fraction number won’t change to date automatically.

But I don’t suggest you use a space. Because in time of removing duplicates the spaces might cause troubles.

3. Stop Fraction Changing to Date Using Zero Before Numbers

Instead of using a space before a fraction number, you can use a zero (0).

❶ Just select a cell first.

❷ Then insert a zero (0) from your keyboard.

❸ Then press the Space button to insert a space.

❹ After that, insert your fraction number.

❺ Finally press the ENTER button.

The zero will vanish automatically. This is how you can prevent your fractions from changing to dates.

4. Using Apostrophe (‘) to Stop Fraction Changing to Date

You can also insert an apostrophe (‘) before your fraction numbers instead of using a zero (0). After you press ENTER, the apostrophe will also vanish before the fraction numbers.

❶ First select a cell.

❷ Then insert an apostrophe (‘).

❸ After that, type a fraction number.

❹ Then press ENTER.

The apostrophe will vanish and the fraction numbers will be preserved intact.

Read More: How to Make Fractions Smaller in Excel 

5. Applying Fraction Format for Fraction Numbers

Lastly, you can set your cell format to Fraction to stop your fraction numbers from changing to dates.

❶ First of all, select all the cells.

❷ Then press CTRL + 1.

This will open the Format Cells dialog box.

❸ After that, select Number ➤ Fraction ➤ Up to two digits (21/25).

Based on your preference, you can try other options. Such as,

Up to one digit (¼), Up to three digits (312/943), etc.

❹ Then press OK.

Now try inserting your fraction numbers. This time your fraction numbers won’t change to dates.

Download Practice Workbook

You can download the Excel file from the following link and practice along with it.

Conclusion

To sum up, we have discussed 5 solutions to stop fractions from changing to date in Excel. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries ASAP.

Related Articles

• How to Format Fraction to Percentage in Excel 
• How to Add a Stacked Fraction in Excel 
• Convert Fraction to Decimal in Excel

<< Go Back to Fraction in Excel | Number Format | Learn Excel