Formating Excel 2007 cells.

  • Thread starter Thread starter Chuckc
  • Start date Start date
C

Chuckc

While creating a simple finacial spread sheet in Excel 2007, with all cells
formatted for negative numbers to be displayed in red and a $. I took note
that numbers displayed as a result of a mathmatical calc. IE simple
subtraction, didn't display as formated. If the number was a negative it
showed up with a minus sign and no $. If I enter it with the keyboard it
shows up correctly, even in that particular cell. I hade to go back to excel
2000 to get it to work, and it does work as advertized!!! Microsoft bug?????
 
Hi Chuck,

How exactly did you format the cells?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| While creating a simple finacial spread sheet in Excel 2007, with all cells
| formatted for negative numbers to be displayed in red and a $. I took note
| that numbers displayed as a result of a mathmatical calc. IE simple
| subtraction, didn't display as formated. If the number was a negative it
| showed up with a minus sign and no $. If I enter it with the keyboard it
| shows up correctly, even in that particular cell. I hade to go back to excel
| 2000 to get it to work, and it does work as advertized!!! Microsoft bug?????
 
Back
Top