Get an instance of the formatter then pass in the format index from the cell style.
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFData Format.html#getFormat(short) http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFWork book.html#createDataFormat() http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFCell Style.html#getDataFormat() Shawn -----Original Message----- From: Avik Sengupta [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 3:03 AM To: poi-dev@jakarta.apache.org Subject: data format Dumb question: How does one get the data format of an existing cell (ie, excel file read in by POI) as a string (ie, as '#0.00') TIA - Avik --------------------------------------------------------------------- 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/