Forum Discussion
Exel konverter
NikolinoDE Thank you but it does not work
The problem occurs when I download an excel file from an English website and the transfer is like this
361.36 and in DK we have all our digital figures like this 361,36
I can change each cell but then I have 300 rows and it takes a lot of time to change all those cells into digital figures from . to ,
So hopefully someone knows how I can change all the row automatically.
Change the character used to separate thousands or decimals
Click File > Options.
On the Advanced tab, under Editing options, clear the Use system separators check box.
Type new separators in the Decimal separator and Thousands separator boxes.
click on options
click on advanced and see "Use System Separators on the bottom. Uncheck that box and change the decimal separator to a comma.
Hope this helps.
