Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
I trying to change -3210 to (3120) but can't find how to do it. Can anyone
help me? I'm using the 2003 version. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
Select the cell, then goto Menu FormatCellsCustom, and add 0;(0)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sarah" wrote in message ... I trying to change -3210 to (3120) but can't find how to do it. Can anyone help me? I'm using the 2003 version. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
Hi,
Put -1 in a cell and copy it. Select the cell with -3210 in and then Edit|Paste special Select multiply and OK. Delete the cell with -1 in Mike "Sarah" wrote: I trying to change -3210 to (3120) but can't find how to do it. Can anyone help me? I'm using the 2003 version. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
Click Format Cells Number tab
Choose Number under "Category", set the dp to zero, select the desired bracket format from the list under "Negative numbers" OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Sarah" wrote: I trying to change -3210 to (3120) but can't find how to do it. Can anyone help me? I'm using the 2003 version. Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
I suppose I should read posts before answering!!
Try a Custom format of 0_);(0) Mike "Mike H" wrote: Hi, Put -1 in a cell and copy it. Select the cell with -3210 in and then Edit|Paste special Select multiply and OK. Delete the cell with -1 in Mike "Sarah" wrote: I trying to change -3210 to (3120) but can't find how to do it. Can anyone help me? I'm using the 2003 version. Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
Mike that didn't work. I got 1,716,536,781,789
I just want to put brackets round my minus number but all I get is the minus sign. Any more ideas?? "Mike H" wrote: Hi, Put -1 in a cell and copy it. Select the cell with -3210 in and then Edit|Paste special Select multiply and OK. Delete the cell with -1 in Mike "Sarah" wrote: I trying to change -3210 to (3120) but can't find how to do it. Can anyone help me? I'm using the 2003 version. Thanks |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
Sarah,
I may have confused you with my first and incorrect post. With the number -1234 in a cell select that cell then:- Format|Cell|Number Select custom and paste in the formula 0_);(0) Click OK and theminus sign will turn to (1234) Mike "Sarah" wrote: Mike that didn't work. I got 1,716,536,781,789 I just want to put brackets round my minus number but all I get is the minus sign. Any more ideas?? "Mike H" wrote: Hi, Put -1 in a cell and copy it. Select the cell with -3210 in and then Edit|Paste special Select multiply and OK. Delete the cell with -1 in Mike "Sarah" wrote: I trying to change -3210 to (3120) but can't find how to do it. Can anyone help me? I'm using the 2003 version. Thanks |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
Max wrote:
Click Format Cells Number tab Choose Number under "Category", set the dp to zero, select the desired bracket format from the list under "Negative numbers" OK I trying to change -3210 to (3120) but can't find how to do it. Can anyone help me? I'm using the 2003 version. Thanks Hi , Click Format Cells Custom and type #,##0;(#,# # 0) in Type..Press OK and that's done. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
"sidm" <u38329@uwe wrote in message news:79d3aaec40511@uwe...
Click Format Cells Custom and type #,##0;(#,# # 0) in Type..Press OK and that's done. Is the above preferable to the simple menu command in Format Cells for the OP's purpose here, I wonder ? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
Max wrote:
Click Format Cells Custom and type #,##0;(#,# # 0) in Type..Press OK and that's done. Is the above preferable to the simple menu command in Format Cells for the OP's purpose here, I wonder ? I tried your method ,it does not work on my excel 2003 SP2.It would have been simpler though. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
"sidm" <u38329@uwe wrote
I tried your method ,it does not work on my excel 2003 SP2. It would have been simpler though. I'm using xl2003, too Wonder which part of my response doesn't work for you?: Click Format Cells Number tab Choose Number under "Category", set the dp to zero, select the desired bracket format from the list under "Negative numbers" OK Over here, under "Negative numbers", for the bracket format, I can click to select either: (1234) (1234) [in red] -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
If negative brackets are not available in the NumberNegative 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 Wed, 17 Oct 2007 04:22:03 -0700, Sarah wrote: I just want to put brackets round my minus number but all I get is the minus sign. Any more ideas?? |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
Ah, I see Gord's posting in the other branch.
It's something to do with regional settings -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing - to ()
Max wrote:
Ah, I see Gord's posting in the other branch. It's something to do with regional settings I think that might be the case as well..Thanks for the input. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the TAB key | Excel Discussion (Misc queries) | |||
changing a cell to changing the link | Excel Worksheet Functions | |||
NOW() keeps changing | Excel Discussion (Misc queries) | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
changing #value! to 0's | Excel Worksheet Functions |