TANKPETERS9846 TANKPETERS9846
  • 01-09-2017
  • Business
contestada

You have a list of european stocks that are priced in euros. where can you go to format the prices in euros in excel?

Respuesta :

LearnGrow
LearnGrow LearnGrow
  • 11-09-2017
To convert prices in euros in dollars it means you should make Currency Conversion. In order to do the currency conversion you should take several steps in Excel:
1. Select a blank cell next to the price in Euros and enter the formula =NUMBERVALUE(A2,",","."). 
Now you will have the amount. If you also want to have the symbol for dollars you should:
2. Format the cell: Right click-> Format->Currency and select the currency.

Answer Link

Otras preguntas

Name one state that borders Canada
Under our Constitution, some powers belong to the states. What is one power of the states?
What is one thing Benjamin Franklin is famous for?
Name one problem that led to the Civil War.
what is the value of the underlined digit in 56.123? one is underlined
Which term represents a type of nuclear reaction? (1) condensation (2) vaporization (3) single replacement (4) natural transmutation
HOW WOULD YOU BE ABLE TO IDENTIFY streptococci THROUGH A MICROSCOPE
Given the balanced equation representing a reaction: Al2(SO4)3 +6NaOH ==> 2Al(OH)3 + 3Na2SO4 The mole ratio of NaOH to Al(OH)3 is (1) 1:1 (2) 3:1 (3) 1:3 (
When lithium reacts with bromine to form the compound LiBr each lithium atom (1) gains one electron and becomes a negatively charged ion (2) gains three electro
What is one thing Benjamin Franklin is famous for?