How do I change numbers in a worksheet to a currency and change a number of columns at the same time?

Thanks

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’t and you need further clarification then please press the Reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.

Many Thanks

Mark East
MOUS Master Instructor