Format Cell Modern Activity Help

[Betul_Dundar (Betül Dündar)]

Hi all!

I want to use format cells modern activity. But what can i write here for this(0,00) format ?

In this photo custom type doesnt work.

[Lekshmi_R]

Hi,
Can you make it little more specific?
What will be a sample input and an expected output?

[Anil_G (Anil Gorthi)]

@Betul_Dundar

Can you please give an example of number how it should look…

because #,##0 will give the format as without decimals for example…1.23 will be 1

And the same format is tried and the result is as expected

pleaase let us know the format you need accordingly we can suggest

cheers

[Betul_Dundar (Betül Dündar)]

Expected output is 0,00
@Lekshmi_R

[Anil_G (Anil Gorthi)]

@Betul_Dundar

Is comma the separator in your case?

if so please try 0.00 or 0,00

cheers

[Gokul_Jayakumar (Gokul Jai)]

Hello @Betul_Dundar , If your Excel setting is coma as a decimal separator, then Try this