How to Exchange "," with "." when pasting into Numbers?

I am pasting amounts like 314.60 into Numbers (the program).
I would like it to automaticaly change 314.60 to 314,60, so simply exchange the "." to ",".

Long time since I postet anything here or did program any macro. I might be rusty so please forgive.

This works for me. You want to have a Group set up (probably called numbers!) that is only available in numbers, so this macro doesn't fire anytime you paste. You could also use a different hotkey, like shift-cmd-V, in case you ever wanted to paste text that had a full-stop, or at least have some sort of method for that in case you ever wanted to do it. Perhaps set Shift-Cmd-V to a regular paste for example.

Let me know if you have any questions.

Change . to - in numbers.kmmacros (2.1 KB)

2 Likes

Thanks!