Works 2000: Data Formatted to Use the Euro Currency Symbol Does Not Copy/Paste Correctly (239169)


The information in this article applies to:

  • Microsoft Works 2000
  • Microsoft Works Suite 2000
This article was previously published under Q239169

SYMPTOMS

When you copy a Works Spreadsheet column that has been formatted to use the Euro currency symbol (?), and then you paste the column to another Works Spreadsheet file also formatted to use the Euro symbol, it pastes as dollars.

When you copy a Works Database cell that has been formatted to use the Euro symbol (?), and then you paste the cell to a Works Spreadsheet cell also formatted to use the Euro symbol, it pastes as dollars.

When you copy data that has been formatted to use the Euro symbol (?), and then you paste the data to an unformatted Works Spreadsheet file, it pastes as dollars.

When you copy a Works Spreadsheet column that has been formatted to use the Euro symbol, and then you paste the column to another column in the same Works Spreadsheet file (formatted or not), it pastes as the Euro symbol.

WORKAROUND

To work around this problem, format the cell or column that has the incorrect monetary symbol after the data has been pasted.

To format a cell or column to use the Euro currency symbol, follow these steps:
  1. In Works Spreadsheet, select the column or cell that you want to format.
  2. On the Format menu, click Number.
  3. On the Number tab, under Format, click Currency.
  4. Under Options, click to select the Use euro symbol [?] check box, and then click OK.

    The Euro symbol now appears in place of the dollar sign.

STATUS

Microsoft has confirmed that this is a problem in Works 2000.
Modification Type:MajorLast Reviewed:6/28/2004
Keywords:kbbug kbpending KB239169
©2004 Microsoft Corporation. All rights reserved.