Iam running Excel 2003.
When I want to format a cell with a currency, Iam given a list of currency formats from $(canada), $(USA), £, EURO, EURO(Ireland), EURO(Spain), £ Scotish etc....
There appears to be over 100 different options.
The only symbols I use are $ USA, Euro(Ireland) and £ British.
Is there any way to either
1) Shorten the available options to the 3 I use on a regular basis or
2) Promote the 3 I use so that they are the first shown in the dropdown list
Thanks in advance
When I want to format a cell with a currency, Iam given a list of currency formats from $(canada), $(USA), £, EURO, EURO(Ireland), EURO(Spain), £ Scotish etc....
There appears to be over 100 different options.
The only symbols I use are $ USA, Euro(Ireland) and £ British.
Is there any way to either
1) Shorten the available options to the 3 I use on a regular basis or
2) Promote the 3 I use so that they are the first shown in the dropdown list
Thanks in advance