Adding "[ ]" to a number
 

Is there a way to add brackets, [ ], to a number in excel? This is just for
asthetic purposes (to show that a number is in draft form), not to designate
a negative number. Thank you!

Adding "[ ]" to a number
 

try this,

go to format--cell-- custom format-- type "["0"]"

now when you type a number it will add [] around it

"Meredith" wrote:

Is there a way to add brackets, [ ], to a number in excel? This is just for
asthetic purposes (to show that a number is in draft form), not to designate
a negative number. Thank you!

Adding "[ ]" to a number
 

Custom format:

\[#.##\]
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Meredith" wrote in message
...
Is there a way to add brackets, [ ], to a number in excel? This is just for
asthetic purposes (to show that a number is in draft form), not to designate
a negative number. Thank you!

Adding "[ ]" to a number
 

FormatCellNumber custom format \[0\]

HTH
--
AP

"Meredith" a écrit dans le message de
news: ...
Is there a way to add brackets, [ ], to a number in excel? This is just
for
asthetic purposes (to show that a number is in draft form), not to
designate
a negative number. Thank you!

Adding "[ ]" to a number
 

Thank you!

"Nikki" wrote:

try this,

go to format--cell-- custom format-- type "["0"]"

now when you type a number it will add [] around it

"Meredith" wrote:

Is there a way to add brackets, [ ], to a number in excel? This is just for
asthetic purposes (to show that a number is in draft form), not to designate
a negative number. Thank you!