Microsoft KB Archive/215726

= XL2000: Currency Formats Lost Saving to Non-Default File Formats =

Article ID: 215726

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q215726



SYMPTOMS
When you open a workbook, cells formatted with the Currency or Accounting number format appear formatted with a General number format.



CAUSE
This problem occurs when you do the following:


 * 1) You format cells using either the Currency or Accounting number format.

-and-
 * 1) You use any currency symbol other than the default $ symbol.

-and-
 * 1) You save your workbook using one of the following file formats.


 * 1) * Microsoft Excel 5.0/95 Workbook
 * 2) * Microsoft Excel 4.0 Worksheet
 * 3) * Microsoft Excel 3.0 Worksheet
 * 4) * Microsoft Excel 2.1 Worksheet
 * 5) * Microsoft Excel 4.0 Workbook
 * 6) * WK4(1-2-3)
 * 7) * WK3(1-2-3)
 * 8) * WK1(1-2-3)
 * 9) * WKS(1-2-3)
 * 10) * WQ1(Quattro Pro/DOS)



RESOLUTION
If you need to share the workbook with users using a previous version of Microsoft Excel, use the Microsoft Excel 97-2000 & 5.0/95 Workbook format.

For additional information, please see the following article in the Microsoft Knowledge Base:

214237 XL2000: Using Excel 2000 Files with Earlier Versions of Excel



MORE INFORMATION
Microsoft Excel 2000 provides support for many types of currency symbols as defined by the International Organization for Standards (ISO). Earlier versions of Excel and the non-Excel file formats listed earlier do not offer these international currencies. When saving to these file formats, Excel does not retain these unsupported currency symbols.

For example, if you apply the currency format in cell A1 using the Euro currency symbol, and then save the workbook in the Microsoft Excel 5.0/95 Workbook format, when you next open this workbook, the number format for cell A1 will be reset to General and the Euro symbol will not appear.

For more information about what is lost saving to the Microsoft Excel 5.0/95 Workbook format, please see the following article in the Microsoft Knowledge Base.

179824 XL2000: Features and Formatting Lost Saving to Excel 5.0/95

Additional query words: XL2000

Keywords: kbprb KB215726

-

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

© Microsoft Corporation. All rights reserved.