cell formatting

Matis · Mar 26th, 2002, 12:17 PM

Hi, how do I format negative numbers to appear in brackets. E.g -6 becomes (6), -3 becomes (3). Thanks

paelinck · Mar 26th, 2002, 12:23 PM

Use conditional formatting, e.g.:

0.00;(0.00)

This will display all numbers with two decimal places and negative numbers with brackets around them.

Marc

Von Pookie · Mar 26th, 2002, 12:23 PM

Select the cells you want to format, and go to Format/Cells. On the Number tab, choose "Number" from the list. You can then choose how you want to show negative numbers in those cells.

Mar 26th, 2002, 12:23 PM	#3
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Select the cells you want to format, and go to Format/Cells. On the Number tab, choose "Number" from the list. You can then choose how you want to show negative numbers in those cells. __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 12:17 PM	#1
Matis New Member Join Date: Mar 2002 Posts: 27	Hi, how do I format negative numbers to appear in brackets. E.g -6 becomes (6), -3 becomes (3). Thanks

Mar 26th, 2002, 12:23 PM	#2
paelinck Board Regular Join Date: Mar 2002 Location: Leiden, The Netherlands Posts: 68	Use conditional formatting, e.g.: 0.00;(0.00) This will display all numbers with two decimal places and negative numbers with brackets around them. Marc