Do you realize that *before* you choose exactly what formats you wish to
use, you *must* select (choose) the cells that you want to have that
specific format.

If you want the entire sheet to have a certain format, select the entire
sheet first by clicking in the grey square to the left of the column headers
and above the row headers.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"kevin" wrote in message
...
Hi.
I am using Microsoft Excell and can not format the data in the cells as I
want.
For example, I want to format the cells with the dollar sign and right
justified but when I click on the buttons under format cells, it does not
do
what I want.

I have no idea why this does not work but it seems like it should.
I have tried it at least 20 times and it never works or gives me any
indication why.

It may be that there is some mode or something turned on that I do not
know
about.
Please help.
Thanks.