98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training class - Currencies
excel training class - Currencies
Resolved · Low Priority · Version Standard
Clinton has attended:
Excel Intermediate course
Currencies
How do I use different currencies on one s/s?
RE: currencies
Hi Clinton
to use different currencies in one spreadsheet is quiet straight forward really for starters you will need to know where you need to use these.
Then select the cells you need to use a specific currencies the you need to go to the format menu then click on cells, from there choose the number tab from the top of the window, choose currency on the left after that click on the drop list for symbol choose the one you want then click on OK.
For other formats that you need all you need to do is repeat the process as above
hope this helps you out
Mark East
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:View a unique listYou have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column. |