Regarding decimal formatting

[skiruthigadevi]

Hello Friends,

Appreciate your time. I am trying to get the below format for my sales values  in Euro. Could you provide your feedback on the same?

current   format:  €1,2345

expected format: €1,23

I tried a bunch of formatting like '#,##0.0',#.##0,00 and so on.,but its not working.

could you kindly provide your suggestions!

Thank you!

[JuanGerardo · Accepted solution]

Have you tried this?

€#,##0.00;(€#,##0.00)

JG

[skiruthigadevi]

It worked.,thank you!