> >> Is there any way in Excel to show the non-rounded number? just put ' to make it to string in the Excel. Also the non-rounded number is displayed in the formula bar.
Shinya ----- Original Message ----- From: "Dale Monti" <[EMAIL PROTECTED]> To: "POI Users List" <[email protected]> Sent: Wednesday, May 10, 2006 2:16 PM Subject: Re: Excel values and rounding? Urgent!!!! > Could someone please take a look at this, this is becoming a real > problem for me. > Thanks!! > > Dale Monti wrote: > > I could really use some help with this. Please help. > > > > I've attached the spread sheet. > > > > Thanks > > > > > >> Hi, > >> 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 > >> 0.02142000000000000000000 , after I increased the decimal positions. > >> > >> Is there any way in Excel to show the non-rounded number? > >> > >> Or > >> 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. > >> > >> 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/ > >> > >> > > ------------------------------------------------------------------------ > > > > --------------------------------------------------------------------- > > 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/ > --------------------------------------------------------------------- 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/
