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 does not accept text format! 0
Found few bugs in my daily routine of work in excel for MAC 0
How can the font and size of (all) citation numbers be altered? 1
Found few bugs in my daily routine of work in excel for MAC 0
How to count the numbers in a Word document? 0
Template with fields and premade texts.. 0
Macro that will ignore all information within Parentheses 1
Inconsistent formatting of section numbers 0

Top