Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My preference of formatting cells with dollar signs is to align the dollar
sign adjacent to the leftmost number rather than aligning it to the left side of the cell. Excels Currency formatting feature does this whereas the Accounting format aligns the $ to the left side of the cell. I would like to use the toolbar to easily format a cell using the Currency formatting style so the dollar sign is aligned as I desire rather than the longer process of using the Excel menu <FORMAT <CELL etc. The dollar sign icon on the Formatting toolbar uses the Accounting formatting style rather than the Currency style. I cannot figure a way to get an icon on the toolbar to format a cell using the Currency formatting. Is there a way to get Currency formatting onto the toolbar? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Currency, Percent and Comma Style buttons | Excel Worksheet Functions | |||
XL invoice replace the dollar sign with euro sign | New Users to Excel | |||
How do I align numbers where one number has a dollar sign? | Charts and Charting in Excel | |||
Currency Style button | Excel Discussion (Misc queries) | |||
Changing Dollar sign to another currency not listed in Excel | Excel Discussion (Misc queries) |