ACC2000: MS Excel Currency Displayed Incorrectly in Import WizardID: Q210615
|
When you import a Microsoft Excel spreadsheet into Microsoft Access, currency is not displayed correctly in the Import Spreadsheet Wizard. There may be extra zeros to the right of the decimal place in the sample data. However, when you open the resulting table, you see that the data has been imported correctly.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
A1: $1.00
A2: $2.00
A3: $3.25
For more information about importing or linking data from Excel, click Microsoft Access Help on the
Help menu, type "import data from a spreadsheet" in the Office Assistant or the Answer Wizard,
and then click Search to view the topic.
Additional query words: zeroes pra
Keywords : kbinterop kbdta IntpOff IsmExl5 WzProb
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug
Last Reviewed: May 13, 1999