Decimals vanish when using excel-template for ADI reports (Excel 97)

P

Per Magnus L?vold

Hi!
I have made an Excel template for presenting ADI reports, bur I have
some problems with decimal deissapearing when publishing to Excel 97
(works fine with Excel 2002)

Details:
A report is submitted from Oracle Applications (OA) via ADI.
The report is generated by OA, and uses '.' as decimal separator.
The report is imported into Excel (formated by an Excel template). At
my PC with Excel 2002 this works fine. I can see at:
Tools -> Options... under the "International" tab that the Decimal
separator is set to ',' but still it works here. Decimal numbers
appear correct anyway.
F.ex: "9.2" appears as "9,2"
and "3.14" appears as "3,14" (both correct)

However, when trying to publish the same report in Excel 97, the
report is wrong. All the decimals have dissapeared.
F.ex: "9.2" appears as "92"
or "3.14" appears as "314" (both terribly wrong!)
I suspect this could be caused by Excel 97 since it works fine with
Excel 2002.

Does anybody know how to fix this problem in Excel 97?

Regards,
Per Magnus
 
Top