Misleading Number Formats

This rule identifies cells containing formulas that have a different number format to the one applied to the destination cell.

Smart Tag Menu

Update Format - Copies the number format from the dependent cell and applies it to the cell containing the formula.
Help on this Error - Displays the Help task pane.
Ignore Error - This removes the green triangle from the cell and the cell is no longer considered an error.
Edit in Formula Bar - Places the cursor into the Formula bar so it can be edited.
Error Checking Options - Displays the Options, Formulas Tab.

Example

When the number format of a cell containing a formula is different to the number format of one of the dependent cells.
Enter the value "10%" into cell "B2".

Enter the formula "=B2" into cell "B4".

Select cell "B2".
Right mouse click and select "Format Cells".
Display the Number tab and change the category to "Time".

Press OK.