01-02-2019 05:53 AM
01-02-2019 05:53 AM
hi community! i'm having trouble with the number formatting of the axis in charts (excel). but let me get the basics out first:
i'm working on a microsoft office 356 pro plus licence on a mac. the number formatting on the os-level is british, with the advanced settings set to point as decimal separator. the number format in excel is the same: point as separator. this works perfectly in all charts. i can use functions and everything, so he gets my number formatting.
now here is the problem: if i plot anything in a chart, the axis will have a number formatting with a comma separator. even though the numbers on which the chart is based have the british format (point separator), the chart treats them like german format (comma separator). this is also visible when hovering over the plot: the value preview will be depicted in german format.
formatting the axis manually doesn't produce the expected results either. it offers formats like #.##0,0 but if i try to set #,##0.0 it doesn't accept my input. upon hitting enter, my input is automatically changed to #,##00 and the result is accordingly.
the microsoft office support, though very friendly, felt he didn't know a solution and pointed me towards this forum. do you have a suggestion? thanks in advance anyway :)
01-03-2019 06:18 AM
lol ok i fixed the problem.
fun fact: if you install office, it seems to permanently remember the language/number format of your os. another fun fact: this also applies to the new fancy mac os mojave dark mode. i didn't notice that before, but all other apps complied with dark mode, except office apps.
this means office won't switch some setting, even if you change them on all levels. in my eyes, that's a bug, but hey, if you want to convince me it's actually a feature, i'm all ears ;)
so my fix: uninstall and reinstall office AFTER you set all os-settings as desired.
note to the microsoft it-gods: create a ticket ;)