Numbers

Just tell numbers what format it should use to display your value.

Format dates, currency, and more in Numbers on Mac - Apple Support

Format > Cell

Hope this will solve your question, please let me know if this worked for you or if something in unclear.

Ralf

As annoying as it is at times, you have to put the comma yourself.

(do not worry, this will not confuse the program)