A Alanna 10 New Member May 7, 2014 #1 Please can someone tell me how I can sort a currency symbol list so the main currencies I use are at the top of the list. I get tired of looking for them in the list. I usually use the accounting format.
Please can someone tell me how I can sort a currency symbol list so the main currencies I use are at the top of the list. I get tired of looking for them in the list. I usually use the accounting format.
Hui Excel Ninja Staff member May 7, 2014 #2 You can't But you could add a custom Button with a Macro to set the desired effect What exact Currency Format do you use?
You can't But you could add a custom Button with a Macro to set the desired effect What exact Currency Format do you use?
A Alanna 10 New Member May 8, 2014 #3 Just Rand and USD - it was getting so annoying looking for the Rand symbol as its used so much in my tables
Just Rand and USD - it was getting so annoying looking for the Rand symbol as its used so much in my tables
Hui Excel Ninja Staff member May 8, 2014 #4 Actually if you Right Click the Ribbon Customise the Ribbon Select Main tabs in the Right Pane Click on Home, Number, You can add, rearrange or delete the existing formats You could also add a custom Button to add a Rand Currency
Actually if you Right Click the Ribbon Customise the Ribbon Select Main tabs in the Right Pane Click on Home, Number, You can add, rearrange or delete the existing formats You could also add a custom Button to add a Rand Currency
