 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Align Numbers To The Right
I am new to Excel and was practicing with a worksheet. I wanted only to place a $ sign at the first number in the column. When I go to the next line without using a $ sign and type only my number the alignment is slightly off to the right. For example: $ 91, 000 9,000 How can I correct this? Thanks, CJ Try highlighting the cells, then Rignt-click > formatCells > AlignmentTab > select Right in the Horizontal: box > OK Vaya con Dios, Chuck, CABGx3 > I am new to Excel and was practicing with a worksheet. I wanted only to > place a $ sign at the first number in the column. When I go to the next [quoted text clipped - 5 lines] > Thanks, > CJ use Format, Cells, Custom to find out what the format is for the cell with the $ sign that you created with format, cells, number you want the same ending in your other format. Use of an underscore indicates space holder that is as wide as the character that follows. The chart at http://www.mvps.org/dmcritchie/excel/formula.htm#GetFormat may help to show you what you are looking for. Certainly installing the GetFormat user defined function would help you with many similar problems. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Try highlighting the cells, then Rignt-click > formatCells > AlignmentTab > > select Right in the Horizontal: box > OK [quoted text clipped - 11 lines] > > Thanks, > > CJ Thanks much for your help. C J > use Format, Cells, Custom to find out what the format is > for the cell with the $ sign that you created with format, cells, number [quoted text clipped - 28 lines] > > > Thanks, > > > CJ
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.