negative figures

  • Thread starter Thread starter Guest
  • Start date Start date
Hi
apply the following custom format (goto 'format - Cells'):
0.00;(-0.00)
 
Mariah

Format | Cells... | Number tab | Custom | Type: #,##0;(#,##0)

Regards

Trevor
 
Right click on the cell, choose Format Cells... Click on Number under
Category:
Then choose how you want negative numbers displayed.
 
Hi Mariah!

If this will always be your preferred format you can change the format
for negative numbers using:

Start > Settings > Control Panel > Regional Options
Make changes on the Numbers and Currency Tabs
Apply
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
-----Original Message-----
I want to display in a cell -9048.00 as (9048.00)
.
1)Right click on the cell or
Click to expand...
2)Choose format,cells on the tool bar or
3)Press CTRL 1
then click the Number tab and choose how you want the
number to display on the right side of the window
Beach
 
You must log in or register to reply here.

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

Red cell for negative numbers in Excel 1
Postive # converted to Negative # 7
Divide two cells and if the number is negative display is as zero 2
Rounding Negative Numbers to Zero 4
if negative figure 8
Need Help with "SUM" AND "ABS" in same formula 12
Negative time calculations 4
Eliminate Negatives 3

Back
Top