Formating Excel 2007 cells.

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

Niek Otten

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

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

Top