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

Use commas as decimal separator
 

Give this a try...

= A2&" "&SUBSTITUTE(TEXT(B2,"0.00"),".",",")

--
Rick (MVP - Excel)


"Edwin" wrote in message
...
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

Use commas as decimal separator
 

Wow! This is just what I needed! Thanks a lot Rick!!
--
Edwin


"Rick Rothstein" wrote:

Give this a try...

= A2&" "&SUBSTITUTE(TEXT(B2,"0.00"),".",",")

--
Rick (MVP - Excel)


"Edwin" wrote in message
...
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