cell format doesn't take place

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a formula that subtracts one cell from another. For example:
$10,000 - $4,000 = $6,000. However, in the cell with the answer ($6,000), it
displays as 6000. I tried changing the cell formatting, but no matter what I
do, the "sample" doesn't change. It insists on 6000. If I remove the
formula, and put in $6,000 manually, it will display as $6,000. Am I missing
something?
 
What is the cell formatting now?

Is there conditional formatting in that cell?
 
the cell formatting is number, with the 1,000 separator and no conditional
formatting in that cell. I just can't get it to change in Excel 2007
 
How about formatting the number 6000 to Currency?

Does that work?


Gord Dibben MS Excel MVP
 
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

vlookup: source is specific and table is a range 2
Excel doesn't sort zip codes properly 4
Increase by % Formula 6
Help in resoloving scenario 1
Can I condition format, "if the cell contains a formula" 3
SUMIF 1
Formula text in woorksheet cell 2
Macro or Formula? 1

Back
Top