Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
kevin
 
Posts: n/a
Default 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.
  #2   Report Post  
Ragdyer
 
Posts: n/a
Default

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
format census tract numbers a_rust Excel Worksheet Functions 1 March 7th 05 10:18 PM
format existing numbers in excel? Robin Excel Discussion (Misc queries) 6 March 3rd 05 11:11 PM
Combining data (numeric format) in multiple cells into one cell (t GNAC SID Excel Discussion (Misc queries) 2 February 7th 05 04:09 PM
format cell data to display stacked data dkay10 Excel Discussion (Misc queries) 1 January 17th 05 02:20 AM
Using Microsoft Query data in a pivot table. slapana Charts and Charting in Excel 0 January 11th 05 05:03 PM


All times are GMT +1. The time now is 03:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"