Format: enclose content of cells in parantheses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

awkwardpause101@gmail.com - 20 Feb 2007 01:44 GMT

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

Reply to this Message

Dave Peterson - 20 Feb 2007 01:52 GMT

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.

> Hi there,
>
[quoted text clipped - 7 lines]
>
> lamasoft

Signature

Dave Peterson

Reply to this Message

lamasoft - 21 Feb 2007 02:17 GMT

> Maybe you could use a column with formulas like:
>
[quoted text clipped - 24 lines]
>
> Dave Peterson

Yup, that works--thanks!

Reply to this Message

Andy - 21 Feb 2007 04:54 GMT

> 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.

Reply to this Message