SOLVED
Home

Excel for Mac - Point as separator in a German Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1183979%22%20slang%3D%22en-US%22%3EExcel%20for%20Mac%20-%20Point%20as%20separator%20in%20a%20German%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1183979%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there!%3CBR%20%2F%3EI%20working%20with%20Excel%20for%20Mac%20on%20my%20MacBook%20Air%20with%20OS%20X%20Catalina.%20My%20Excel%20language%20is%20german%20(I%20from%20Austria).%20Is%20there%20any%20possibility%20to%20change%20the%20separator%20from%20comma%20to%20point%20(without%20changing%20the%20OS%20language%20or%20the%20language%20in%20Excel)%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1183979%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1184122%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%20-%20Point%20as%20separator%20in%20a%20German%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1184122%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F563891%22%20target%3D%22_blank%22%3E%40Mr_Geo91%3C%2FA%3E%26nbsp%3BIn%20English%3A%20Apple%20symbol%20top%20left%2C%20System%20Preferences%2C%20Language%20%26amp%3B%20Region%2C%20Advanced...%20should%20bring%20you%20to%20this%20screen.%20Here%20you%20can%20set%20your%20preferences.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-02-20%20at%2011.19.15.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F172189i312FCA7A86F3C022%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-02-20%20at%2011.19.15.png%22%20alt%3D%22Screenshot%202020-02-20%20at%2011.19.15.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1184212%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%20-%20Point%20as%20separator%20in%20a%20German%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1184212%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20your%20effort%2C%20but%20this%20system%20change%20don't%20work%20in%20Excel.%20Excel%20is%20changing%2040.5793%20to%20405.793%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3CBR%20%2F%3EGreets!%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1184263%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%20-%20Point%20as%20separator%20in%20a%20German%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1184263%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F563891%22%20target%3D%22_blank%22%3E%40Mr_Geo91%3C%2FA%3E%26nbsp%3BHow%20strange.%20I%20have%20tried%20on%20both%20my%20MBP%20and%20MB%20air%20(on%20Catalina).%20When%20I%20change%20the%20thousand%20and%2For%20decimal%20separator%20in%20systems%20settings%2C%20Excel%20picks-up%20the%20new%20settings%20%3CU%3Eafter%3C%2FU%3E%20the%20next%20start-up.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1187376%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%20-%20Point%20as%20separator%20in%20a%20German%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1187376%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BHey%20Riny%2C%20now%20it%20works.%20I%20really%20don't%20know%20why%2C%20but%20after%20restarting%20Excel%20two%20times%20the%20separator%20was%20set%20to%20a%20point.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20a%20lot%20for%20your%20help!%3CBR%20%2F%3E%3CBR%20%2F%3EGreets%2C%3C%2FP%3E%3CP%3EMr_Geo91%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi there!
I working with Excel for Mac on my MacBook Air with OS X Catalina. My Excel language is german (I from Austria). Is there any possibility to change the separator from comma to point (without changing the OS language or the language in Excel)?

Thanks!

4 Replies
Highlighted
Solution

@Mr_Geo91 In English: Apple symbol top left, System Preferences, Language & Region, Advanced... should bring you to this screen. Here you can set your preferences.

Screenshot 2020-02-20 at 11.19.15.png

Highlighted

Thank you for your effort, but this system change don't work in Excel. Excel is changing 40.5793 to 405.793

Greets!


Highlighted

@Mr_Geo91 How strange. I have tried on both my MBP and MB air (on Catalina). When I change the thousand and/or decimal separator in systems settings, Excel picks-up the new settings after the next start-up.

Highlighted

@Riny_van_Eekelen Hey Riny, now it works. I really don't know why, but after restarting Excel two times the separator was set to a point.

Thanks a lot for your help!

Greets,

Mr_Geo91

Related Conversations
Help with counting formula
AL789 in Excel on
1 Replies
Excel hangs up during execution of any operation
Rohit_Agrawal in Excel on
0 Replies
how to create custom number format permanently
iman89 in Excel on
0 Replies
drop-down list vs if-then vs ??
thetis in Excel on
0 Replies
RTD
adriangray in Excel on
0 Replies
Convert Days to whole months
SPC123 in Excel on
2 Replies