SOLVED

Automatically recognise thousand separators

%3CLINGO-SUB%20id%3D%22lingo-sub-1418037%22%20slang%3D%22en-US%22%3EAutomatically%20recognise%20thousand%20separators%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1418037%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20Excel%20to%20automatically%20insert%20a%20thousand%20separator%20whenever%20I%20type%20in%20let's%20say%201000%20or%201000000.%20Thus%2C%20Excel%20should%20automatically%20display%20this%20as%201%2C000%20and%201%2C000%2C000.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20how%20to%20do%20it%20manually%2C%20but%20I%20want%20to%20prevent%20myself%20from%20doing%20this%20ever%20again%2C%20so%20that%20requires%20a%20change%20in%20the%20setting%20of%20the%20programme.%20Basically%2C%20whenever%20I%20open%20a%20new%20workbook%2C%20it%20should%20automatically%20apply%20the%20rule%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20anyone%20share%20his%2Fher%20insights%20on%20this%20topic%3F%20That%20would%20be%20extremely%20helpful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20%26amp%3B%20best%2C%3C%2FP%3E%3CP%3EThorsten%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1418037%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1418349%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20recognise%20thousand%20separators%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1418349%22%20slang%3D%22en-US%22%3EUse%20an%20empty%2C%20one-sheet%20workbook.%3CBR%20%2F%3EFold%20out%20the%20Styles%20gallery%20(Home%20tab).%20Right-click%20the%20%22Normal%22%20style%20and%20choose%20Modify.%3CBR%20%2F%3EChange%20the%20number%20format%20to%20the%20one%20you%20want%20Excel%20to%20always%20use.%3CBR%20%2F%3ENow%20choose%20File%2C%20Save-as%2C%20select%20%22Excel%20template%22%20(either%20with%20or%20without%20macro's)%3CBR%20%2F%3Ename%20your%20file%20book.xltx%20(or%20xltm)%20and%20save%20it%20in%20this%20folder%3A%3CBR%20%2F%3E%25appdata%25%5CMicrosoft%5CExcel%5CXLSTART%3CBR%20%2F%3EDo%20the%20same%20again%2C%20this%20time%20name%20your%20file%20Sheet.xltx%20(this%20is%20the%20new%20sheet%20template).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1419662%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20recognise%20thousand%20separators%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1419662%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%2C%20problem%20solved!%20In%20the%20meantime%20I%20found%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcustomize-how-excel-starts-in-excel-for-mac-8f3c2396-3883-4e3e-a668-8254aeff6a0f%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ethis%20website%3C%2FA%3E%26nbsp%3Bthat%20provides%20more%20detailed%20information%20on%20how%20to%20change%20the%20default%20style%20of%20excel%20workbooks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 

2 Replies
Highlighted
Best Response confirmed by TP101 (New Contributor)
Solution
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).
Highlighted

Thank you, problem solved! In the meantime I found this website that provides more detailed information on how to change the default style of excel workbooks.