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

ID: Q210568

The information in this article applies to:

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 this to be a problem in the Microsoft products 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          : kbdta wd2000 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: May 21, 1999