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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
