Brackets or paranthesis around negative numbers in Excel
 

Does Excel have a format?

Brackets or paranthesis around negative numbers in Excel
 

Try Custom format #,##0;(#,##0)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lorne" wrote in message
...
Does Excel have a format?

Brackets or paranthesis around negative numbers in Excel
 

Format Cell , on the Number tab select Number and choose the negative
number format.

You can also use Format, Cell and on the Number tab select Accounting.

"Lorne" wrote:

Does Excel have a format?

Brackets or paranthesis around negative numbers in Excel
 

Thanks Bernard. I'm new and you and Dav have opened a new door in Excel for
me.


"Bernard Liengme" wrote:

Try Custom format #,##0;(#,##0)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lorne" wrote in message
...
Does Excel have a format?