https://issues.apache.org/ooo/show_bug.cgi?id=15773
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #51 from [email protected] --- 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.
