Symbols

Below are some cases of a Flag Symbol Might Appear:

1. Conditional Formatting with Icon Sets

• Excel may be using an icon set (like flags, arrows, or traffic lights) to visually represent values.
• These icons can replace or overlay the actual number.

Fix it:

• Select the column with the flags.
• Go to Home > Conditional Formatting > Manage Rules.
• Look for any rule using Icon Sets.
• Either edit the rule to show the number alongside the icon, or delete the rule.

2. Custom Number Format

• Someone might’ve applied a custom format that replaces numbers with symbols.

Fix it:

• Select the cell.
• Right-click > Format Cells > Number tab.
• Choose General or Number to reset formatting.

3. Wingdings or Symbol Font

• If the font is set to Wingdings, numbers will appear as symbols.

Fix it:

• Select the cell.
• Go to Home > Font and change it to Calibri, Arial, or any standard font.

Hi johnmpace​ , It sounds like the column might have conditional formatting applied specifically an icon set that replaces numbers with symbols like flags.

This can happen if the sheet was previously set up to visually represent values using icons.

To fix this in Excel:

1. Select the column showing the flag.
2. Go to Home > Conditional Formatting > Manage Rules.
3. Look for any rules applying icon sets (like flags) and either edit or delete them.
4. Alternatively, you can clear all formatting by selecting the column and choosing Home > Clear > Clear Formats.

Once removed, your numbers should display normally.

Let us know if you're using a different app or need help adjusting the formatting!