Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel
how do i set up $(230) for negative values instead of "-" in excel
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel
On Aug 3, 9:37*am, SGM wrote:
how do i set up $(230) for negative values instead of "-" in excel On way: Format Cells Number Accounting. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel
If negative brackets are not available in the
FormatCellsNumberNumberNegative Numbers dialog. 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. Gord Dibben Excel MVP On Sun, 3 Aug 2008 09:37:00 -0700, SGM wrote: how do i set up $(230) for negative values instead of "-" in excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|