Formating Excel 2007 cells.
 

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?????

Formating Excel 2007 cells.
 

Hi Chuck,

How exactly did you format the cells?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Chuckc" wrote in message ...
| 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?????