You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/02/01 09:14:39 UTC

[Bug 15773] Currency symbol left justified, while amount right justified in a cell (accounting notation).

https://issues.apache.org/ooo/show_bug.cgi?id=15773

dave_hudson@hotmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dave_hudson@hotmail.com

--- Comment #51 from dave_hudson@hotmail.com ---
I'm new to spreadsheets, but did some BASIC programming many, many years ago.

Here's what I came up with...I know it's a bit long winded, but it seems to
work well from initial tests. I've never used Excel so I can't compare the
results. Please let me know if it works for you.

=CONCATENATE("£";REPT(" ";10-LEN(TEXT(F3;"#####0.##")));TEXT(F3;"##0.##"))

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.