Format: enclose content of cells in parantheses

[awkwardpause101]

Hi there,

Is there an easy way to automatically format the contents of the cell
in any given column so that the content (text and numbers) are
enclosed in parentheses?

So, for example, 'random info' becomes ('random info')?

Thanks,

lamasoft

 

[Dave Peterson]

Maybe you could use a column with formulas like:

=if(a1="","","("&a1&")")
And copy down the column.

Then select that column
Edit|copy
edit|Paste special|values

and delete the original column.

 

[lamasoft]

Maybe you could use a column with formulas like:

=if(a1="","","("&a1&")")
And copy down the column.

Then select that column
Edit|copy
edit|Paste special|values

and delete the original column.

Yup, that works--thanks!

 

[Andy]

Is there an easy way to automatically format the contents of the cell

in any given column so that the content (text and numbers) are
enclosed in parentheses?

Select "Custom" in Format Cells and insert:

"("#,##0.00")";[Red]"("#,##0.00")";;"("@")"

You'll have to adjust the number formatting as you like. Here the
numbers will have commas and two decimal places, negative numbers in
red. Zeros won't show.