Forum Discussion
Tina_Schulz1895
Dec 15, 2022Copper Contributor
Exel konverter
Hello How can I translate a whole sheet from an English number value to a Danish number value? I have a whole sheet. It will take a long time if I have to change every cell instead of getting...
NikolinoDE
Gold Contributor
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.
kcalloway
Dec 15, 2022Copper Contributor
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.