Formatting Excel Formulas and Their Cells

When you type a formula into Excel, the result sometimes looks wrong. A growth rate shows as a bare decimal instead of a percentage, a date appears as a five-digit number, or the whole formula sits in the cell as plain text. These are display problems, not calculation problems. Learning how to format Excel formulas mostly comes down to separating what a cell calculates from how that result is shown.

This guide is for people who build spreadsheets for budgets, schedules, grade books or reports and need the results to look right. It covers three things: number formats for the displayed value, conditional formatting driven by a formula, and the common causes of strikethrough or formula-looking text. The fixes apply to any Excel workbook.

You will get a decision table, a checklist to run before you change anything, step-by-step instructions, and a way to verify the result. If your workbook is an .xlsx file you plan to translate, OmniDoc keeps layout and formulas in the output, but you still need to check the numbers yourself.

How to format Excel formulas so the results look right? The short answer

Apply a number format to the cell that holds the formula when you want a fixed look, and use a formula inside conditional formatting when the look should depend on the data. Change a cell's font only when you want that style permanently.

Your situation	What to do	Why
The result shows as a decimal or a serial number	Apply a number, percentage, currency or date format to the formula cell	The format changes the display; the stored value and later calculations stay the same
The look should change when the data meets a condition	Add a conditional formatting rule that uses a formula returning TRUE or FALSE	The rule re-evaluates as the data changes, so you do not edit cells by hand
You want to flag cells that lost their formula	Use a rule such as =NOT(ISFORMULA(A2)) on the range	It highlights cells that were typed over or pasted as values
A cell shows strikethrough you did not apply	Check conditional rules and copied font styles before editing the cell	Strikethrough usually comes from a rule or an inherited format
The whole formula appears as text	Check whether the cell is formatted as Text or whether a view setting shows formulas	Text-formatted cells store the formula as plain text and do not calculate

Before you start

Run through these checks first. Each one prevents a common reason that formatting seems to fail.

Confirm the cell is actually calculating. Click the cell and read the formula bar. A typed number that looks like a result will not change when your data changes. The reason: formatting a constant does not fix a broken formula.
Check the cell's current format. If the cell is set to Text, Excel will not calculate a formula you enter into it. The reason: you may need to change the format before anything else works.
Decide whether the look is fixed or conditional. Fixed formatting stays the same no matter what the data says. Conditional formatting follows the values. The reason: picking the wrong type leads to rules you have to rebuild later.
Save a copy of the workbook. Formatting rules are easy to add and hard to trace after many edits. The reason: you can compare against the original if something breaks.
Pick a small test range of 10 to 20 rows. Build and test rules there before applying them to the whole sheet. The reason: a rule that misfires on 20 rows is easy to spot; one that misfires on 20,000 is not.

Formatting a formula's result in Excel, step by step

Follow these steps for a fixed look or a value-based highlight. Start with the number format, then add a rule if you need one.

Select only the cells that hold the formula. Limit the selection to the results you want to change. The reason: formatting an entire column can hide errors in cells you did not mean to touch.
Open the cell formatting settings and choose a category. Pick number, percentage, currency or date to match what the formula returns. The reason: the category tells Excel how to display the stored number.
Set decimal places and the thousands separator. Keep two decimal places for money and none for counts. The reason: rounding affects only what you see, because the full value is still stored.
Use a custom format for anything the categories do not cover. A code such as #,##0.00 shows two decimal places with a thousands separator, and a code such as #,##0 shows whole numbers with separators. The reason: custom codes let you match a house style without changing the formula.
Open conditional formatting and create a new rule that uses a formula. Choose the option for formula-based rules rather than a simple value comparison. The reason: a formula can test more than one cell and handle blanks or text.
Enter the formula relative to the first cell of the range. For a range that starts at A2, use =NOT(ISFORMULA(A2)) so Excel adjusts the reference for each row. The reason: an absolute reference would test the same cell everywhere.
Choose the format the rule applies. Pick a fill color, a font color or a font style. The reason: a simple, consistent format is easier to read than several competing styles.
Review the rule list for the range. Check that each rule covers the cells you expect and that rules do not conflict. The reason: when two rules touch the same cell, the one higher in the list usually wins for the properties they share.

The ISFORMULA rule also flags empty cells, because a blank cell is not a formula. If you want to flag only typed values, use =AND(A2<>"",NOT(ISFORMULA(A2))) instead.

Check the result

Once the formatting is in place, check it against the values behind it. This table lists what to look at and what to change.

Check	How to see it	If it's wrong
The display matches the value	Click the cell and compare the formula bar result with the displayed text	Change the number format; the stored value is not affected
The rule highlights the right cells	Open the conditional formatting rules for the range and test a few rows	Fix relative or absolute references and reorder the rules
The strikethrough has a source	Clear the format on a copy of the cell and see whether the strikethrough remains	Remove the conditional rule or the copied font style
The formula calculates	The cell shows a result, not the formula text	Change the format from Text to a general format, then enter the formula again
The translated workbook still works	Compare key formulas and results in the output with the original file	Review the affected sheets and correct any figures that changed

❓ FAQ

1. Does formatting a formula cell change its result?

No. Number formats and conditional formatting change only how the cell looks. The formula still calculates the same stored value, so totals and other formulas that use that cell are unaffected.

2. Why do my TEXT function results not add up?

The TEXT function returns text, not a number. Excel's SUM and similar functions skip text values, so a column of TEXT results can total to zero. Keep the formula that returns a number, and use a number format to control how it looks.

3. Why does my cell show ##### instead of the number?

The column is too narrow to display the value with its formatting. Widen the column. The stored value is fine; only the display is cut off.

4. Will my conditional formatting survive translation in OmniDoc?

OmniDoc's translation keeps the layout, tables and formulas of supported files, including .xlsx. This article does not describe how conditional rules are handled, so open the translated workbook and test each rule before you rely on it.

📝 Summary

Formatting a formula's result is about display: use number formats for a fixed look and formula-based conditional rules when the look should follow the data. When strikethrough or formula text appears unexpectedly, check the rules, the copied styles and the cell format before you change the formula itself. Learning how to format Excel formulas this way keeps your calculations intact while the results look the way you need.

Open OmniDoc to work on your spreadsheets