Hmmm. Did that. Used that string. Had to escape the double quotes. Got cells that SAY they are formatted as accounting with a $ and 2 decimal places, but that still do not LOOK like that.
See the attached jpg. -----Original Message----- From: Andrew C. Oliver [mailto:acoliver@;apache.org] Sent: Wednesday, November 06, 2002 5:31 PM To: POI Users List Subject: Re: HSSFDataFormat and accounting formats? select accounting, click ok. Go back to the cell and click custom.... you get: "_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)" Now why couldn't you guess that string off the top of your head? haha ;-) -Andy Amon, Jennifer wrote: >Thanks, but I don't know how to find that. From within Excel, it just shows >a $ and separately lets me specify a number of decimal places. I have no >idea what that format would look like. > >Jennifer > >-----Original Message----- >From: Andrew C. Oliver [mailto:acoliver@;apache.org] >Sent: Wednesday, November 06, 2002 5:08 PM >To: POI Users List >Subject: Re: HSSFDataFormat and accounting formats? > > >Yes, basically find the format string you would use in excel, and use >that for HSSF. > >-Andy > >Amon, Jennifer wrote: > > > >>I can find the currency formats, but not the accounting formats >>in the javadoc for HSSFDataFormat. The doc also says that >>user defined formats may be used. One way or >>another, can I get the dollar signs and decimal points to line >>up in the column? >> >>Thank you, >> Jennifer Amon >> >>-------------------------------------------------------------------------- - >> >> >- > > >>---------- >>Jennifer R. Amon Work Phone: 440-962-2471 >>Moen Incorporated Work Fax: 440-962-2739 >>25300 Al Moen Drive Work Email: [EMAIL PROTECTED] >>North Olmsted, OH 44070 Personal Email: [EMAIL PROTECTED] >> Web: http://junior.apk.net/~jamon/ >>-------------------------------------------------------------------------- - >> >> >- > > >>---------- >> >> >>________________________________________________________________________ >>This email has been scanned for all known viruses. >>_______________________________________________________________________ >> >>-- >>To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> >>For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org> >> >> >> >> >> >> > > > >-- >To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> >For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org> > > >________________________________________________________________________ >This email has been scanned for all known viruses prior to entering the Moen >network. >________________________________________________________________________ > >________________________________________________________________________ >This email has been scanned for all known viruses. >_______________________________________________________________________ > >-- >To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> >For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org> > > > > -- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org> ________________________________________________________________________ This email has been scanned for all known viruses prior to entering the Moen network. ________________________________________________________________________ ________________________________________________________________________ This email has been scanned for all known viruses. _______________________________________________________________________
<<attachment: AccountFmt.jpg>>
-- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
