Misleading Number Formats

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

alt text

Smart Tag Menu

alt text

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".

alt text

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

alt text

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

alt text

Press OK.

alt text

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext