have negative numbers appear in parenthesis

[Byrna West]

How does one do this? I only see options for negative numbers to
appear with a (-) sign or in red. I prefer them in parenthesis
(Windows Excel allows this). Any suggestions?

 

[Art]

How does one do this? I only see options for negative numbers to
appear with a (-) sign or in red. I prefer them in parenthesis
(Windows Excel allows this). Any suggestions?

Byrna,
On Office X, those format options exist for both numeric and currency
styles (Format / Cells / Number command and Number or Currency category).

If they're not present on your version of Excel, you can recreate them.
There are templates under the "custom" category that you can use as a
starting point.

Art

 

[JE McGimpsey]

How does one do this? I only see options for negative numbers to
appear with a (-) sign or in red. I prefer them in parenthesis
(Windows Excel allows this). Any suggestions?

MacXL allows this too...<g>

Choose Format/Cells/Number/Number, and choose the format you want from
the Negative numbers: listbox.

If you want a custom format, you can use Format/Cells/Number/Custom.

 

[Fairgreen]

Byrna,
On Office X, those format options exist for both numeric and currency
styles (Format / Cells / Number command and Number or Currency category).

If they're not present on your version of Excel, you can recreate them.
There are templates under the "custom" category that you can use as a
starting point.

Art

Yes, I'm familiar with custom categories. But, I'm unable to save
them for future reference. In other words, I have to recreate the
style each time it's required. How does one save it for future use?

 

[JE McGimpsey]

Yes, I'm familiar with custom categories. But, I'm unable to save
them for future reference. In other words, I have to recreate the
style each time it's required. How does one save it for future use?

Hmmm...

It appears in XL04 by default, and, IIRC, did so in XLv.X as well.

Since you don't see the format you want, create a fresh workbook, set a
cell or cells to the custom format (then change the cell(s) back to
General if desired), and save it as your default template (make any
other changes you want to save, too, such as fonts, number of
worksheets, column widths, etc.).

See the "Create a template for workbooks or worksheets" topic in Help
for more info.

 

[Fairgreen]

Hmmm...

It appears in XL04 by default, and, IIRC, did so in XLv.X as well.

Since you don't see the format you want, create a fresh workbook, set a
cell or cells to the custom format (then change the cell(s) back to
General if desired), and save it as your default template (make any
other changes you want to save, too, such as fonts, number of
worksheets, column widths, etc.).

See the "Create a template for workbooks or worksheets" topic in Help
for more info.

hmmm. I'm not sure if this will work. If I create a template which
uses parenthesis for negatives, wouldn't it then revert to (-) when I
choose currency format? I need all numbers (currency, accounting,
numbers) to use parenthesis for negative..do you see what I mean?
shoudl I create a macro (which I've never done...so no sure how to...)