Microsoft KB Archive/291207

= XL2002: Bullets Not Retained When You Paste Selection from Word =

Article ID: 291207

Article Last Modified on 5/21/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q291207



For a Microsoft Excel 2000 version of this article, see 230934.



SYMPTOMS
When you paste a selection from Microsoft Word that contains bullet formatting, the bullet formatting may not be retained.



CAUSE
Excel removes bullet formatting when you paste a selection.



WORKAROUND
To add a bullet to text in a cell, create the bullet by using its American National Standards Institute (ANSI) code. You can enter this character by copying the character from the Character Map program that is included with Windows, or by entering a keystroke combination. To enter a keystroke combination, hold down ALT and type a four-digit number on the numeric keypad. Note, you cannot type this number from the number keys at the top of the keyboard.

If you are using the Times New Roman font, the keystroke for the bullet character is ALT+0149. To create the bullet, click the cell, hold down ALT and type 0149 on the numeric keypad.

If you don't know the ANSI code for the bullet character or you want to use a different bullet character, you can determine the character code or insert the character by using the Character Map program. To do this, follow these steps.

NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.


 * 1) Click Start, point to Programs, point to Accessories, point to System Tools, and then click Character Map.
 * 2) In the Font list, select the font that you are using to format the text in Excel.
 * 3) In the table, click the bullet character. Note the keystroke combination that appears in the lower-right corner of the Character Map dialog box.
 * 4) At this point you can do one of the following:
 * 5) * Copy the character. To do this, click the symbol, click Select, and then click Copy. Switch to Excel and then click Paste on the Edit menu.

-or-
 * 1) * Switch to Excel and type the keystroke.
 * 2) In Character Map, click Close.

NOTE: You can also apply a custom format in Microsoft Excel that uses the bullet symbol. For additional information about how to do this, click the article number below to view the article in the Microsoft Knowledge Base:

323567 XL: How to Create a Bullet List in Microsoft Excel



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2002

Keywords: kbbug kbinterop kbpending KB291207

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.