Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I convert decimal commas to decimal points? | Excel Discussion (Misc queries) | |||
Combobox changes the decimal commas to dots - How to prevent it? | Excel Discussion (Misc queries) | |||
Format Cell to Overwrite Decimal Separator in Options | Excel Discussion (Misc queries) | |||
How do I change the way the decimal separator displays? | Excel Discussion (Misc queries) | |||
convert imported data with . separator for decimal into , separato | Excel Discussion (Misc queries) |