How to change the decimal point on the numeric keypad to a comma

I work using Excel (on a Mac) and need to have numbers separated by a comma. My Belkin numeric keypad only has a decimal point on instead of a comma. Before I installed Excel 2016, I was able to change the decimal point to show as a comma when I typed it. Now, something has reset and I can't change it back to a comma. I have tried the Language & Region - Advanced - Number Separators - changed the full stop for a comma, but it doesn't seem to be working. It is really important for the speed of my work in Excel to be able to press the decimal point on my numeric keypad and for it to read as a comma to separate the numbers I type.
Hope someone can help.
Thanks a million.

Couldn't you just change the column 'format' to 'Number, 'Use 1000 seperator (,) within Excel ?

Not sure where it would be for Excel 2016, but try searching for Use system separators in Excel Options --> Advanced and change the settings there.

RETRACTED (My bad, doesnt work on 2016)

Thanks so much anyway - I appreciate it. It's driving me nuts now...hehe

Originally Posted by quekbc

RETRACTED (My bad, doesnt work on 2016)

Originally Posted by Jtec75

Thanks so much for your reply. Unfortunately, my company needs the column to be formatted as 'Text'. I changed the decimal point for a comma on my numeric keypad before, but now I have Excel 2016 it doesn't seem to work like that anymore.

You are left with two options then in that case:

1) Change to a Logitech Keyboard

or

2) Change companies

Originally Posted by BlindAlley

You are left with two options then in that case:

1) Change to a Logitech Keyboard

or

2) Change companies

Hehe, thanks very much. Not sure yet which will make me happier...

Excel preferences (command+,)
Autocorrect
Replace .
With ,

Now, I can use the numeric keypad of my Mac.I type ., Excel switches to ,

I finally figured it out:
I changed the language on my mac to Spanish keyboard and then my numeric keypad registers the decimal point as a comma when pressed.(I then switch languages back at the end of the job with Command L)