| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
