Problem with MS excel(Parallels).

I can't find the formula (=aggregat) in Swedish. When I change language to English in settings, it's there. I've contacted Microsoft support without any success. They thought it's anything I running office 365 on virtuell machine on a Mac. Any suggestions?

Posted on May 15, 2025 7:06 AM

Similar questions

how to change the character used to separate thousands in Excel to "." in OS Ventura. Do you know how I could get to the "Advanced Settings" tab of Language and Region? I want to change the character used to separate thousands, so in Excel, 1 million appears like 1.000.000,00. I changed this in OS Monterey, but it didn't work, but now we don't even have that option anymore.
1781 2
Change decimals from commas to dots in Excel For some reason, my version of Excel on my MacBook Air has changed all of the decimals in my numbers to commas - ie it has changed my formatting from North American to European. I can work with that, but I'd much rather use the North American. All of the answers to how to do this that I can find on the Web and on this Forum tell me to go to headings on my Excel file that do not exist. For example, on this Forum I was told to go to Advanced under File. There is no Advanced on my Excel. Is there a simple way to switch to North American style?
2662 4
Macos Sonoma - Excel wrong number format I'm using my Mac in Belgium with numbers in a format with comma as decimals and dots (or space) for thousand separators (see screenshot). Seems to be OK in "numbers.app" and is presented correctly as numbers (example 1.235,00). However, in Excel (last version), numbers are presented with dots for decimals and commas for thousand separators. I've tried everything even a terminal command to force the correct number format for maOS but cannot find the reason why Excel keeps using the wrong number format by default. Any idea ?
1090 1

1 reply

Tom Gewecke

Level 10

121,998 points

May 15, 2025 10:08 AM in response to kennet85

Do you mean the Aggregate function, which is supposed to be MÄNGD in Swedish?

Have you asked also in the windows Excel forum?

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_unknown-mso_OPwin?sort=LastReplyDate&dir=Desc&tab=All&status=all&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=all&isFilterExpanded=true&page=1

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Problem with MS excel(Parallels).

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up