Negative formatting ( ), central alignment, no decimal

[Dewdrop]

Dear Guru,

Appreciate your help to share the custom formula for negative formatting with ( ), central alignment with no decimal, red colour for negative number. Please see file attached.

Thank you very much.

Cheers!
Dewdrop

[Rick Rothstein]

Use Cell Formatting.. set the alignment to Horizontal Center and use this Custom Format...

#,##0;[Red](#,##0)

[Dewdrop]

Hi Rick, thank you for your sharing.

Cheers!