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

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

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

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