Excel 2000
Mike
If the brackets option is not available
underFormatCellNumber................
This is a function of your Regional Settings in Windows OS.
StartSettingsControl PanelRegional and Language SettingsRegional
OptionsCustomizeCurrencyNegative Currency Format. Click on drop-down arrow
and select the ($1.1)
Note: this is under the "Currency" tab in Regional Options. Changing under
the "Numbers" tab only does not do the trick.
Apply and OKApply your way out.
You will have to close Excel then re-open to see effects.
Gord Dibben Excel MVP
On Tue, 22 Nov 2005 12:28:06 +0000, Roger Govier
wrote:
Hi Mike
Try
FormatCellsNumberCustom
$#,##0.00;[Red]($#,##0.00)
Regards
Roger Govier
Mike wrote:
Hi - I use Excel 2000 and wish to display negative number, accounting and
currency values in parentheses. However in the Format Cell function in Excel
there is no option to use parentheses. The only option is to use the -ve
symbol or to display the value in red. How do I display the value in
parentheses.
|