Tom Chilton wrote: > Hi, > > There is also an issue open for this (this is where isers vote for the > feaures they would like to see fixed/updated/intoduced in openoffice. > Register and vote for the issue here > <http://www.openoffice.org/issues/show_bug.cgi?id=15773> > It has typically been open for some time. > > Tom > > > On 4 Apr 2007, at 22:00, Richard Detwiler wrote: > >> SANDRA SCHREIBER wrote: >>> I am attempting to use an "acccounting" alignment for currency in >>> Oo2.2 Calc. I need to line up dollar signs, thousands, hundreds, >>> tens, decimal points, etc., but cannot figure how to do so. Please >>> (1) advise if I can do that in this program and if so (2) how to >>> format the cell to accomplish this. See example below. >>> $1,000.00 >>> $ 500.00 >>> $ 15.00 >>> $ 5.00 >>> $ .50 >>> Thank you. >> >> Sandra: >> >> I know the format that you're attempting to achieve; in Excel, I >> believe it was called "Accounting" or something like that, as opposed >> to just "Currency" (which would not have the dollar signs lined up >> like you desire). >> >> Unfortunately, I do not believe there is any way of doing this in >> Calc. This is one of the relatively few things that can be done in >> Excel and doesn't have an equivalent in Calc. >> >> When this question came up once before, someone suggested adding a >> narrow column to the left of the numbers, and put dollar signs in >> that column. To me, this seemed to cumbersome to be practical, and it >> certainly isn't very elegant. But I thought I'd pass this suggestion >> along. >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >>
Can this be done with user defined numbers and format codes? -- Use OpenOffice.org <http://www.openoffice.org> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
