Use commas as decimal separator

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top