You need to use FIXED like the following:
=CONCATENATE(FIXED(A3;2);"some text")
Thanks,
Chris Cheney
--
FIXED
Returns a number as text with a specified number of decimal places and
optional thousands separators.
Syntax
FIXED(Number; decimals; no thousands separators)
Number refers to the number to be formatted.
Decimals refers to the number of decimal places to be displayed.
No thousands separators (optional) determines whether the thousands
separator is used. If the parameter is a number not equal to 0, the
thousands separator is suppressed. If the parameter is equal to 0 or if
it is missing altogether, the thousands separators of your current
locale setting are displayed.
Example
FIXED(1234567.89;3) returns 1,234,567.890 as a text string.
FIXED(1234567.89;3;1) returns 1234567.890 as a text string.
** Changed in: openoffice.org (Ubuntu)
Status: Unconfirmed => Rejected
--
OOo Calc ; CONCATENATION error ?
https://bugs.launchpad.net/bugs/104084
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug contact for Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
