LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
MikeC
 
Posts: n/a
Default Dollar sign alignment - Accounting vs Currency style

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
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
Currency, Percent and Comma Style buttons Leslie Coover Excel Worksheet Functions 1 January 9th 06 01:02 AM
XL invoice replace the dollar sign with euro sign Pamela casares New Users to Excel 2 December 16th 05 08:21 PM
How do I align numbers where one number has a dollar sign? Carter Devereaux Charts and Charting in Excel 1 June 26th 05 07:20 PM
Currency Style button Anita Excel Discussion (Misc queries) 3 April 18th 05 12:48 AM
Changing Dollar sign to another currency not listed in Excel Rehan Excel Discussion (Misc queries) 1 April 12th 05 04:03 PM


All times are GMT +1. The time now is 05:43 AM.

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

About Us

"It's about Microsoft Excel"