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. Because every time I open a new document, I need to change the values. See the image below to understand what I need, better.
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.
