Re: Excel values and rounding?

[Dale Monti]

I could really use some help with this. Please help.

I've attached the spread sheet.

Thanks

Hi,

0.02142000000000000000000 , after I increased the decimal positions.

Is there any way in Excel to show the non-rounded number?

Or




Thanks



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

I am reading a spread sheet and I am using NumberRecord - getValue() I get a value of 0.021419999999999998. However in Excel the value appears as Should I be doing something else with an ExtendedFormatRecord or something? Maybe something that tells me to round to the 5th decimal position. My user claims I am reading it incorrectly, so I either have to prove to them what the actual number is or do some type of rounding.

patnry.xls
Description: MS-Excel spreadsheet

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/