How do I add in a comma between numbers in excel?

Question

I have a column with multiple numbers which are actually prices but the commas do not show up in the numbers so it shows up like it example 1. I need to add in commas in the numbers and add a euro sign for every number like in example 2.

Example situation now (example 1)

What I want for every column (example 2)

I have tried using custom number formats but it doesn't seem to support what I want to have.

Answer 1

Select your cells and use:

€ 0","00;€ -0","00;€ 0","00

As a custom format.

---

For better understanding, here a link to explain the pattern and below image in more detail.

So the used custom format has now got a format for both Postive numeric values, for negative numeric values and for zero numeric values seperated through the semi-colon.