Forum Discussion
Symbols
When I added a column for floor/level numbers to an existing sheet and I entered a number for the floor, a "Flag" symbol replaced the number
Below are some cases of a Flag Symbol Might Appear:
- 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.
- 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.
- 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.