Dot/Comma Key on my Numeric Keyboard

Hi I have the same issue.

The numbers with a period as a decimal point is interpreted as text.

A workaround is to change the period to a comma.

Have a look at your System Settings > Language and Region >Number format, for me the most acceptable format is 1 234 567,89

My preferred numeric format is 1 234 567.89 but looks like there is no option, yet it is common on a Windows PC from I can remember.

I also asked here:

https://answers.microsoft.com/en-us/msoffice/forum/all/numeric-format-on-mac-vs-windows-in-excel/6be33a53-a105-46ec-8f6e-055e4bc7a936

Try using Shift dot or Option dot and see if you get a comma instead.

The best forum for Excel is often

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

I can't find it right now as I have no access to Excel here, but that's a cell format function

Control + Period on the numpad puts down a comma

Still don't like it. Can't colaberate on documents if the formats differ.