Lol! No problem :)
Bhavik Merchant Webdev (Pvt.) Limited Physical Address: Cnr 9th St & Josiah Tongogara Website: http://www.webdev.co.zw Phone: +263 (0)4 702906 Cell: +263 (0)91372788 -----Original Message----- From: Chris Warr [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 8:15 AM To: POI Users List Subject: RE: Numeric cells with commas I just saw it in the quick-guide, sorry to have jumped the gun. Thanks heaps for the pointer. Chris. > -----Original Message----- > From: Chris Warr > Sent: Monday, 13 September 2004 4:14 PM > To: POI Users List > Subject: RE: Numeric cells with commas > > Sorry to be a dunce, but how do you do that? I'm sorry, I'm a bit of a > noob. > > Chris. > > > -----Original Message----- > > From: bhavik [mailto:[EMAIL PROTECTED] > > Sent: Monday, 13 September 2004 4:25 PM > > To: 'POI Users List' > > Subject: RE: Numeric cells with commas > > > > Hi, > > > > Try setting the cell format to "#,##0.00", don't set the > > type=HSSFCell.CELL_TYPE_NUMERIC. And then simply set your value. It > > should automatically display as you want it. > > > > > > > > Bhavik Merchant > > Webdev (Pvt.) Limited > > Physical Address: Cnr 9th St & Josiah Tongogara > > Website: http://www.webdev.co.zw > > Phone: +263 (0)4 702906 > > Cell: +263 (0)91372788 > > > > -----Original Message----- > > From: Chris Warr [mailto:[EMAIL PROTECTED] > > Sent: Monday, September 13, 2004 7:23 AM > > To: [EMAIL PROTECTED] > > Subject: Numeric cells with commas > > > > > > Hi, I'm trying to add a cell with type=HSSFCell.CELL_TYPE_NUMERIC. I > > have a > > string like '1,234.56'. I want the string to end up with the comma in > > the > > spreadsheet but I want the cell to be numeric. Is this possible? Excel > > lets me type it in. > > > > Chris. > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
