Avatar of Paer Toernell
Paer Toernell
Flag for Thailand

asked on 

Format numbers with different decimal and thousand separator

I'm creating an international spreadsheet with different currency's. On the same sheet i need to display (and calculate):

Invoice 1: 300 000,14 Sek
Invoice 2: 320,000.19 Dollar

Open in new window

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?
Microsoft Excel

Avatar of undefined
Last Comment
Anastasia D. Gavanas

8/22/2022 - Mon