ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Microsoft Excell does not format the data numbers right justified. (https://www.excelbanter.com/excel-discussion-misc-queries/19415-microsoft-excell-does-not-format-data-numbers-right-justified.html)

kevin

Microsoft Excell does not format the data numbers right justified.
 
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.

Ragdyer

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.




All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com