Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 05, 11:17 PM
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  
Old May 16th 05, 11:27 PM
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  
Old May 16th 05, 11:29 PM
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  
Old May 17th 05, 06:26 PM
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 02:01 AM
Adding contents of one cell to a range of cells. CLJinVA Excel Worksheet Functions 1 February 10th 05 10:19 PM
Adding Value within a single cell... Brian Excel Worksheet Functions 4 December 28th 04 08:48 PM


All times are GMT +1. The time now is 05:13 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017