View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Edwin Edwin is offline
external usenet poster
 
Posts: 21
Default 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