Fraction to Decimal in Excel and Sheets

Use Excel and Google Sheets formulas to convert fractions to decimals at scale with clear column layouts.

By Fraction to Decimal Converter Team Published May 19, 2026

Quick answer

Short definition: In spreadsheets, divide the numerator cell by the denominator cell to return a decimal value.
Formula: =A1/B1 or =A1+(B1/C1) for mixed numbers

Introduction

Spreadsheet workflows pair well with spot checks on our Fraction to Decimal Converter.

Formulas keep conversion consistent across dozens or hundreds of rows.

Excel does not replace understanding. It applies the same division rule at scale.

Below you will set up columns, write formulas, and verify results with examples.

What is fraction to decimal conversion in Excel?

It uses cell division to replace fraction pairs with decimal values you can chart, sort, or sum.

The logic matches hand calculation: numerator divided by denominator.

Spreadsheets are ideal for budgets, lab data, and inventory lists where many fractions appear at once.

Formatting cells as Number lets you control decimal places display without changing the stored value logic.

Formula

Simple fraction in two cells: =A2/B2.

Mixed number with whole in A2, numerator in B2, denominator in C2: =A2+(B2/C2).

Manual steps are covered in how to convert fractions to decimals if you need the paper method first.

Step-by-step guide

Set up columns
Use separate columns for whole, numerator, and denominator when needed.
Keep units in a header row so you do not mix data types.
Enter the formula once
Write division in the result column.
Use absolute references if you plan to copy across many rows.
Fill down and format
Copy the formula for the full data set.
Apply decimal place formatting for reporting.
Verify sample rows
Check a few lines with the home converter or mental math.
See fraction to decimal converter for a quick manual comparison method.

Example

A2=3, B2=8, formula =A2/B2 returns 0.375.

A3=2, B3=1, C3=4, formula =A3+(B3/C3) returns 2.25 for the mixed value 2 1/4.

If you need percent, multiply the decimal cell by 100 in a new column.

Keep raw decimals in one column and formatted labels in another to avoid confusion.

Frequently asked questions

Yes. The same division formulas apply in Google Sheets.

Excel can display fractions as text or special number formats. Use explicit division formulas for consistent decimals.

Validate denominators before you fill formulas. Use IFERROR only when your workflow allows it.

Conclusion

Use spreadsheets for bulk conversion and the home calculator for quick spot checks.

Separate columns for whole, numerator, and denominator keep mixed-number formulas reliable.

Format results at the end so reports stay readable.

Check on home tool