E
Edwin
Hi,
I’m 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
I’m trying to create a “sentence†from various cells; here is a simplify
example of what I’m 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 “Tools>Options>International tab†to change the decimal
separator of the document, but I’m 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.
I’m 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
I’m trying to create a “sentence†from various cells; here is a simplify
example of what I’m 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 “Tools>Options>International tab†to change the decimal
separator of the document, but I’m 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.