Forum Discussion
Automatically recognise thousand separators
Hello,
I would like Excel to automatically insert a thousand separator whenever I type in let's say 1000 or 1000000. Thus, Excel should automatically display this as 1,000 and 1,000,000.
I know how to do it manually, but I want to prevent myself from doing this ever again, so that requires a change in the setting of the programme. Basically, whenever I open a new workbook, it should automatically apply the rule above.
Could anyone share his/her insights on this topic? That would be extremely helpful.
Thanks & best,
Thorsten
- Use an empty, one-sheet workbook.
Fold out the Styles gallery (Home tab). Right-click the "Normal" style and choose Modify.
Change the number format to the one you want Excel to always use.
Now choose File, Save-as, select "Excel template" (either with or without macro's)
name your file book.xltx (or xltm) and save it in this folder:
%appdata%\Microsoft\Excel\XLSTART
Do the same again, this time name your file Sheet.xltx (this is the new sheet template).
2 Replies
- Use an empty, one-sheet workbook.
Fold out the Styles gallery (Home tab). Right-click the "Normal" style and choose Modify.
Change the number format to the one you want Excel to always use.
Now choose File, Save-as, select "Excel template" (either with or without macro's)
name your file book.xltx (or xltm) and save it in this folder:
%appdata%\Microsoft\Excel\XLSTART
Do the same again, this time name your file Sheet.xltx (this is the new sheet template).Thank you, problem solved! In the meantime I found https://support.office.com/en-us/article/customize-how-excel-starts-in-excel-for-mac-8f3c2396-3883-4e3e-a668-8254aeff6a0f that provides more detailed information on how to change the default style of excel workbooks.
