Excel Question
Excel Question
- Started
- Last post
- 4 Responses
- phirschybar
In MS Excel, how can I take the value of every cell in one column and wrap it in parenthesis?
So, if the number "5" is one of the cells in that column, it would now say "(5)"?
- fate_redux0
Why would you need to?
- phirschybar0
I need to wrap every cell in parenthesis because I am using an SQL exporter and the column type is 'SET' so I need the parenthesis...
- fate_redux0
Ok, here's how. Select all your cells. go to Format>Cells. Go down to custom and enter (#) in the box. Tada!
- fate_redux0
Ok, here's how. Select all your cells. go to Format>Cells. Go down to custom and enter (#) in the box. Tada!