Currency formatting in Excel

Excel
1

image
image839×325 19.5 KB

Hello @AntrikshSharma ,

i am not able reply to same topic.

but solution is not working for me.
Its working for $(USD) not for Euro.
if anyone able to help me please.

Thanks
Nutan

1 Like
3

@NutanPatil use €#,##0.00

image
image1096×536 30.1 KB

4 Likes
4

LOL…or that

2 Likes
5

Try below Custome format
[>=1000000]“€” ###,###,##0;[>=100000]“€” ###,##0;“€” ##,##0

1 Like
6

@NutanPatil ,

This solution also providing the same output.