Microsoft KB Archive/235105

= XL2000: Currency in Data Table Is Displayed in U.S. Dollars and Not Currency Specified in Regional Settings =

Article ID: 235105

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q235105



SYMPTOMS
In Web page preview, when you view a chart sheet that has a data table containing currency information, the numbers in the data table are displayed in U.S. dollars ($) rather than the currency specified under Regional Settings in Control Panel.

NOTE: The data on the chart retains its currency formatting.



CAUSE
This behavior only occurs when you preview the page by clicking Web Page Preview on the File menu. This behavior does not occur when you save the file as a Web page.

This behavior also does not occur when you use Web Page Preview on a chart and data table embedded on a worksheet.



RESOLUTION
Save the chart as a Web page. To do this, click Save as Web Page on the File menu.

NOTE: The currency is still displayed in U.S. dollars in Web page preview, even after you save the file as a Web page.



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: XL2000 dollar sign

Keywords: kbbug kbpending KB235105

-

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

© Microsoft Corporation. All rights reserved.