excel training class - currencies

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training class - Currencies

excel training class - Currencies

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

View a unique list

You 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.

View all Excel hints and tips


Server loaded in 0.09 secs.