Use commas as decimal separator
Hi,
Im trying to change the decimal separator from a point to a comma (i.e.
200,50 instead of 200.50), but I need some type of function to do this since
Im trying to create a €śsentence€ť from various cells; here is a simplify
example of what Im trying to do:
1 A B
2 10K 200.50
= A2&€ś €ť&B2
The result I get is: 10K 200.50
The result I would like to get is: 10K 200,50
I am aware of the €śToolsOptionsInternational tab€ť to change the decimal
separator of the document, but Im dealing with both, English and Metric
units in the same document; therefore I need to use both separators (points
and commas).
Any help will be greatly appreciated.
--
Edwin
|