RE: Excel 2007; currency

Hi Nicky

Hope you enjoyed your course on Tues the 11th

To change the format of your cells in bulk to a currency is quite easy to do what you do first is

1. highlight the columns you need to change, then from the home ribbon under the number section click on the drop down list to the right of the dollar sign where you will get a list of common currencies that you can apply

2. If the currency does not appear in the list then click the more account formats from the same drop down list

This should do the trick

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn