Forum Discussion
Solved
Opening TXT files and setting default decimal and thousand options
Hello folks. I´d like to know if there is an option on EXCEL to read a txt document, and set the txt import assistant to be always set as English decimal and thousand separator option as default. Bec...
You could make Excel use point as decimal separator and comma as thousands separator independently of your system settings in Windows:
- Select File > Options > Advanced.
- Clear the check box 'Use system settings'.
- Enter a point in the 'Decimal separator' box.
- Enter a comma in the 'Thousands separator' box.
- Click OK.
You could make Excel use point as decimal separator and comma as thousands separator independently of your system settings in Windows:
- Select File > Options > Advanced.
- Clear the check box 'Use system settings'.
- Enter a point in the 'Decimal separator' box.
- Enter a comma in the 'Thousands separator' box.
- Click OK.
- O.M.G. that´s exactly what I was looking for! Thank you darling.
