D
David
Where can i find this formatting option?
TIA
TIA
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Create a custom format of #,##0;(#,##0)
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
C
CarlosAntenna
No need for a custom format.
Format > Cells > Number -- parens are an option in the dialog box.
Carlos
Format > Cells > Number -- parens are an option in the dialog box.
Carlos
G
Gord Dibben
If not available in Format>Cells>Number.....
This is a function of your Regional Settings in Windows OS.
Start>Settings>Control Panel>Regional and Language Settings>Regional
Options>Customize>Currency>Negative Currency Format. Click on drop-down arrow
and select the ($1.1)
Apply and OK>Apply your way out.
You will have to close Excel then re-open to see effects.
Or go Bob's route and add his Format to your Format>Style>Normal
Gord Dibben Excel MVP
This is a function of your Regional Settings in Windows OS.
Start>Settings>Control Panel>Regional and Language Settings>Regional
Options>Customize>Currency>Negative Currency Format. Click on drop-down arrow
and select the ($1.1)
Apply and OK>Apply your way out.
You will have to close Excel then re-open to see effects.
Or go Bob's route and add his Format to your Format>Style>Normal
Gord Dibben Excel MVP