How do I bracket text in cells by formatting a whole column?

[tywlam]

I want to bracket text or number in a cell, eg. abc becomes (abc). Or add
predetermined prefix to a number or text. How can I use the Text function
or other Excel functions to get these kinds of formats?

Thanks

 

[Sheeloo]

With abc in A1
use this in B1
="(" & A1 & ")"
or
=Concatenate("(",A1,")")

 

[Sheeloo]

"I want to bracket text or number in a cell"

Formatting will work only with numbers...