Microsoft KB Archive/210568

= WD2000: Currency Symbol and Numbers May Be Missing or Show As Pound Signs (#) from Excel =

Article ID: 210568

Article Last Modified on 12/6/2000

-

APPLIES TO


 * Microsoft Word 2000 Standard Edition

-



This article was previously published under Q210568



SYMPTOMS
When you open a Microsoft Excel worksheet that contains numbers formatted with a currency symbol (for example the dollar or euro symbol), the currency symbol and numbers may be missing or the numbers may show as pound signs (######).

NOTE: This problem occurs when the numbers in Excel are formatted as Currency or Accounting.



CAUSE
The Excel converter (Excel32.cnv) cannot correctly convert numbers that have the Currency or Accounting format applied in Microsoft Excel.



WORKAROUND
Do not open the Excel file in Word. To work around this problem, use one of the following methods to bring the Excel data into your Word document.

Method 1: Copy and Paste
Copy and paste the contents of the Excel worksheet into your Word document.

NOTE: To link to the Excel worksheet so that changes made in Excel are updated in Word, click Paste Special on the Edit menu, and click to select Paste link.

Method 2: Insert Excel Object

 * 1) On the Insert menu, click Object.
 * 2) On the Create from File tab, click Browse.
 * 3) In the Browse dialog box, point to and select your Excel file.
 * 4) Click Insert.
 * 5) Click OK to close the Object dialog box.

NOTE: If you want to link to the Excel worksheet so that changes made in Excel are updated in Word, click Link to file on the Create from File tab.



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: franc deutsche mark peseta pound lira guilder schilling escudo markka euro krone drachma sterling

Keywords: kbbug kbnofix KB210568

-

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

© Microsoft Corporation. All rights reserved.