displaying numbers in parentheses

Z

zanny101

I would like to display numbers in parentheses but excel automatically reads
it as a formula. Is there a way of formatting the cell so that such numbers
can be displayed? For example I want to enter: -0.15 (1.20)
thanks!
 
Z

zanny101

Thanks for you reply. I tried doing as you suggest but the number was still
read by excel as a formula. Instead I tried typing a single quotation mark '
before the numbers and that seems to be working

regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - display negative numbers with minus sign and parenthe 3
Return Number 2
Excel 2000 8
Negative Numbers in Parentheses 2
Custom format 1
i want to convert decimals into time format 3
Cell reference in formula string displays abbreviated value 2
Displaying negative values in parentheses 3

Top