ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help formating Cells (https://www.excelbanter.com/excel-worksheet-functions/34594-help-formating-cells.html)

Jrr6415sun

Help formating Cells
 

I want a column of my data to be in parenthesis

example 53.85% to be (53.85%)

Is there a fast way to do this? thanks in advance


--
Jrr6415sun
------------------------------------------------------------------------
Jrr6415sun's Profile: http://www.excelforum.com/member.php...o&userid=25064
View this thread: http://www.excelforum.com/showthread...hreadid=385865


Peo Sjoblom

Select the column, do formatcellsnumbercustom and use (0.00%)

--
Regards,

Peo Sjoblom

(No private emails please)


"Jrr6415sun" wrote
in message ...

I want a column of my data to be in parenthesis

example 53.85% to be (53.85%)

Is there a fast way to do this? thanks in advance


--
Jrr6415sun
------------------------------------------------------------------------
Jrr6415sun's Profile:
http://www.excelforum.com/member.php...o&userid=25064
View this thread: http://www.excelforum.com/showthread...hreadid=385865



Gordon

"Jrr6415sun" wrote
in message ...


See my reply in microsoft.public.excel.
Please don't multi post, crosspost instead to not more than three relevant
groups. This ensures that all the replies are in the same place.

Thank you.




All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com