Solved Why is Excel substituing sympol for the letter I

March 16, 2013 at 06:40:43
Specs: Windows 7
I set up the column in Excel to limit entries to 3 options "A" "I" or "P". Randomly, I am getting slim down arrows instead of the "I" entry. Worse, the limitations I imposed allow this to happen. I can fix each individual entry by going to the Insert Symbols, and selecting an "I" from the chart (Ariel, Basic Latin sub-set). But I'd like to prevent this from happening, as many different people will be using this spreadsheet. Any thoughts?

See More: Why is Excel substituing sympol for the letter I

Report •

March 16, 2013 at 06:48:24
It sounds like the "random" cells are formatted for some kind of symbol font.

Have you tried selecting the column and setting the font to something normal like Ariel or Helvetica? Even if the column shows the desired font when selected, change it to something else and then change it back. Try to watch the offending cells when you do this to make sure they change.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

March 16, 2013 at 07:08:58
Thanks for the suggestion. I had the font set for Ariel, but tried your suggestion of reformatting the column in a different font, and changing it back. Unfortunately, no luck. The symbols didn't change. I've also tried resetting the Data Validation, thinking that it might have occurred on rows that I had inserted along the way, but that didn't help either.

Report •

March 24, 2013 at 08:37:08
✔ Best Answer
I finally discovered the answer. Some of the rows in the worksheet were purposely lined out. That affected or conflicted with the column formatting to produce the odd effect

Report •

Related Solutions

Ask Question