You are currently offline, waiting for your internet to reconnect

Inserted symbol is changed to a text character in Excel

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q292478
SYMPTOMS
In Microsoft Excel, when you insert a symbol into a cell and then select another cell or press ENTER, the inserted symbol may be changed into a text character.
CAUSE
This issue can occur when you insert a symbol into a cell while a character-style font is selected in the Font list.
WORKAROUND
To work around this issue, format the cell after you insert the font character that you want. For example, follow these steps:
  1. Start Excel.
  2. In Microsoft Office Excel 2003 and in earlier versions of Excel, click Symbol on the Insert menu.

    In Microsoft Office Excel 2007, click Symbol in the Text group on the Insert tab.
  3. On the Symbols tab, click Webdings in the Font list.
  4. In the Character code box, type 56, click Insert, and then click Close.
  5. Press ENTER.

    Notice that the inserted symbol changes to the numeral 8.
  6. In Excel 2003 and in earlier versions of Excel, click Webdings in the Font list on the Formatting toolbar.

    In Excel 2007, click Webdings in the Font list on the Home tab in the Font group.

    Notice that the text character changes to the symbol that you want.
MORE INFORMATION
When you insert a symbol into a blank cell and then select another cell or press ENTER, the inserted symbol changes to the character equivalent of the currently selected font.
XL2002 prb XL2003 XL2007
Properties

Article ID: 292478 - Last Review: 02/02/2007 00:05:23 - Revision: 2.2

Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition

  • kbtshoot kbexpertisebeginner kbpending kbprb KB292478
Feedback
.name='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> /html>>html>>html>