<div>
I cant get it to work, how do you use that formula if you want a comma as decimal separator?
</div>


Example.xlsx

<div>
Good job Rob, but the author should be aware that these numbers are text now and can not be used in any formulas.
</div>


<div>
Yes and in Sweden the decimal separator is comma and thousand separator is space, and i need them both on the same spreadsheet.
</div>


<div>
great comments and collaborative solution provided by experts
</div>


<div>
<div class="content wysiwyg-content">
I'm creating an international spreadsheet with different currency's. On the same sheet i need to display (and calculate):<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-28966869-1"><span>Invoice 1: 300 000,14 Sek</span>
<span>Invoice 2: 320,000.19 Dollar</span>
</code></pre>
<br />
Sweden and USA have different decimal and thousand separator. How do i format cells so i can control what decimal and thousand separator is used in what cell?
</div>
</div>


I'm creating an international spreadsheet with different currency's. On the same sheet i need to display (and calculate):

(CODE)

Sweden and USA have different decimal and thousand separator. How do i format cells so i can control what decimal and thousand separator is used in what cell?

Format numbers with different decimal and thousand separator

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.