0x17-0x24 is not listed and I don't know if anyone has tried to figure out what those are. I beleive there are other users who have done this, but you should be able to replace the string "($#,##0.00_);[Red]($#,##0.00)" with one that has the yen sign instead of dollar and any other formatting that you want.
Shawn -----Original Message----- From: Janarthan S [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 4:20 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Setting the data format of Cell Style Hi, I am using HSSF in my project. I am using the following code - HSSFCellStyle mStyle = vWorkbook.createCellStyle(); mStyle.setDataFormat(HSSFDataFormat.getFormat("($#,##0.00_);[Red]($#,##0.00) ")); So in the genereated excel sheet i get my o/p as $224,689.91, which is fine for English users. Some of my users are Japanese. I want the yen sign to appear in the generated o/p. Please help me in this regard. I went through the docs for HSSFDataFormat. It said that '0x17 - 0x24 reserved for international and undocumented'. Is it because of this? Is it deferred to the next release ?. Thanks in advance. Regards, Janarthan S --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
