Help with Excel number format - cell formatting

[manekankit]

Looking for excel cell formatting as below. Decimal should be displayed only if present in source data. negative values to be displayed in number.
Amount to be in million comma format/style. Requesting members to help with cell formatting to derive below result.

Input data in cell	Output format / appearance in cell
3.23	3.26
3	3
-3	(3)
-3.23	(3.23)

 

[duggie33]

Change the custom number format to "General;(General)". It won't change 3.23 to 3.26, but should do everything else you want

Hope that helps,

Doug

 

[Joe4]

Change the custom number format to "General;(General)". It won't change 3.23 to 3.26, but should do everything else you want

I am guessing that was probably a typo on their part!