View Single Post
  #4   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Terri,

If you just want the brackets to appear, but not really be in the cell
contents, you can use Format - Cells - Number - Custom:
"["General"]";"["General"]";"["General"]";"["@"]"

Paste it in from this post. If you have numbers that require specific
number formatting, replace the word General with any number format you want.
The first is for positive numbers, then negative, then zero. The last part,
"["@"]" , is for text.

If you want to actually put the brackets into the cells, it will require a
formula in another cell, which could be pasted back over the original stuff
to make the brackets permanent in your original cells. The formula used
depends on what you have in the cells, numbers or text. If any of the
original cells are formulas, they'll have to be modified to include the
brackets; don't use this method, though you can use the first.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Terri" wrote in message
...
I have a column in Excel that I want to enclose the contents with brackets
in
every cell. Is there an easy way to do that?