Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mark Jackson
 
Posts: n/a
Default Adding Parenthsis to a Cell

Hello,

How can I add a parenthesis to a cell? I have a number that is not a
negitive number but I still would like to put a parenthesis aroung it. Any
help is appreciated.

Thanks.
Mark
  #2   Report Post  
Alok
 
Posts: n/a
Default

Do a custom formatting as follows

(General);(-General);(General);

Alok Joshi

"Mark Jackson" wrote:

Hello,

How can I add a parenthesis to a cell? I have a number that is not a
negitive number but I still would like to put a parenthesis aroung it. Any
help is appreciated.

Thanks.
Mark

  #3   Report Post  
CLR
 
Posts: n/a
Default

Right click on the cell, then FormatCells Number tab Custom and in the
Type: window, put ( #### ) OK

Vaya con Dios,
Chuck, CABGx3


"Mark Jackson" wrote in message
...
Hello,

How can I add a parenthesis to a cell? I have a number that is not a
negitive number but I still would like to put a parenthesis aroung it.

Any
help is appreciated.

Thanks.
Mark



  #4   Report Post  
Mark Jackson
 
Posts: n/a
Default

Thanks. That worked great.

Mark

"CLR" wrote:

Right click on the cell, then FormatCells Number tab Custom and in the
Type: window, put ( #### ) OK

Vaya con Dios,
Chuck, CABGx3


"Mark Jackson" wrote in message
...
Hello,

How can I add a parenthesis to a cell? I have a number that is not a
negitive number but I still would like to put a parenthesis aroung it.

Any
help is appreciated.

Thanks.
Mark




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
Adding Smart Tags to an unrecognized cell reference SauveC Excel Discussion (Misc queries) 3 February 12th 05 03:01 AM
Adding contents of one cell to a range of cells. CLJinVA Excel Worksheet Functions 1 February 10th 05 11:19 PM
Adding Value within a single cell... Brian Excel Worksheet Functions 4 December 28th 04 09:48 PM


All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"