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



The information in this article applies to:

  • Microsoft Word 2000

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.

Modification Type:MajorLast Reviewed:12/6/2000
Keywords:kbbug KB210568