Cell format question

[eliW]

Hi all,

How do I format cells so that every input will be surrounded with parentheses?

E.g. my input 35 or FGH
The result: (35) or (FGH)

Eli

 

[parry]

The following custom format will do this but the values already need to be in the cell. If you type a new number in then it seems to treat the number as text. I dont know how to get around this if they need to be numbers but someone may know.

"("General")";"("@")"

 

[eliW]

Thank you parry!
Works fine by just custom (@)
works for numbers and text and not seen when cell is empty.
Thanks again,
Eli

 

[parry]

My pleasure. Ive worked out how to retain numbers as numbers instead of text. This may be important if you need to do any calculations but if you just want text then your right just "("@")" is fine.

"("#,##0")";"("@")"