I have this formula in a cells: =CONCATENATE(“aaa “,TEXT(C2,”#’0.00″))
Cell in C2 has a value of 12350.3.
The result of the formula is: aaa 123500.00
In Excel I get this result: aaa 12’350.00
In Spread then NumberGroupSeparator is missing and the number is multiplied * 10.
How can I format a number as text to be exactly like in Excel?