Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Moving custom number format to NUMBER
Using Excel 2000 from Office 2000:
Lost hard drive from old computer but have a backup. Re-installed MS Office & copied over all (I thought) template files (personal.xls, etc) On new install when I RT click on a cell & look at Format Cells under the number tab, under "Number" there are 2 examples of "-1234" I recall that in prior installation there was a choice for "(1234)" as a negative number.( using brackets vs -ve sign)I know that you can get this format by using Custom, but I thought it was already a choice in Number. Is there a way to move the custom one to Number?? TIA Doug |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Moving custom number format to NUMBER
This is Windows setting.
In Windows Regional Settings you must make the negative number setup under the "Currency" tab. Yes........currency, not Number tab. Gord Dibben MS Excel MVP On Mon, 23 Jul 2007 14:23:21 -0400, Doug Boufford wrote: Using Excel 2000 from Office 2000: Lost hard drive from old computer but have a backup. Re-installed MS Office & copied over all (I thought) template files (personal.xls, etc) On new install when I RT click on a cell & look at Format Cells under the number tab, under "Number" there are 2 examples of "-1234" I recall that in prior installation there was a choice for "(1234)" as a negative number.( using brackets vs -ve sign)I know that you can get this format by using Custom, but I thought it was already a choice in Number. Is there a way to move the custom one to Number?? TIA Doug |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Moving custom number format to NUMBER
ACK - I hate missing the easy ones!!
Many thanks Gord. Doug Gord Dibben wrote: This is Windows setting. In Windows Regional Settings you must make the negative number setup under the "Currency" tab. Yes........currency, not Number tab. Gord Dibben MS Excel MVP On Mon, 23 Jul 2007 14:23:21 -0400, Doug Boufford wrote: Using Excel 2000 from Office 2000: Lost hard drive from old computer but have a backup. Re-installed MS Office & copied over all (I thought) template files (personal.xls, etc) On new install when I RT click on a cell & look at Format Cells under the number tab, under "Number" there are 2 examples of "-1234" I recall that in prior installation there was a choice for "(1234)" as a negative number.( using brackets vs -ve sign)I know that you can get this format by using Custom, but I thought it was already a choice in Number. Is there a way to move the custom one to Number?? TIA Doug |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Moving custom number format to NUMBER
Thanks for the feedback but changing the negative number format under "Currency"
tab in Regional Settings is not very intuitive so it's easy to miss. Gord On Mon, 23 Jul 2007 17:24:48 -0400, Doug Boufford wrote: ACK - I hate missing the easy ones!! Many thanks Gord. Doug Gord Dibben wrote: This is Windows setting. In Windows Regional Settings you must make the negative number setup under the "Currency" tab. Yes........currency, not Number tab. Gord Dibben MS Excel MVP On Mon, 23 Jul 2007 14:23:21 -0400, Doug Boufford wrote: Using Excel 2000 from Office 2000: Lost hard drive from old computer but have a backup. Re-installed MS Office & copied over all (I thought) template files (personal.xls, etc) On new install when I RT click on a cell & look at Format Cells under the number tab, under "Number" there are 2 examples of "-1234" I recall that in prior installation there was a choice for "(1234)" as a negative number.( using brackets vs -ve sign)I know that you can get this format by using Custom, but I thought it was already a choice in Number. Is there a way to move the custom one to Number?? TIA Doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom number format | Excel Discussion (Misc queries) | |||
Custom Number Format | Excel Discussion (Misc queries) | |||
custom number format | Excel Worksheet Functions | |||
Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) | |||
Custom number format | Excel Worksheet Functions |