Adding "[ ]" to a number

M

Meredith

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!
 
N

Nikki

try this,

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

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

RagDyeR

Custom format:

\[#.##\]
--

HTH,

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

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!
 
M

Meredith

Thank you!

Nikki said:
try this,

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

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

Meredith said:
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!
Click to expand...
Click to expand...
 
Top