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

Evaporation: Large amounts of water evaporates from the Earth's ________, _______, __________ every day. The water vapor (evaporation) becomes part of the _____
what causes the earths crust to move ?
What does an acid+base make
A particle is moving along the x-axis so that its position at any time t is greater than and equal to 0 is given by x(t)=2te^-t?A) Find v(t). B) Find a(t).C) At
solve the equation in factoral form   (x+3)(x-2/5=0
solve the equation in factoral form   (x+3)(x-2/5=0
Clarence brought 5 rolls of color film and 4 rolls of black - and - white film for his camera for a total of $24.00. The black - and - white cost $1.50 per roll
what does diametor mean?
7kg of soybean oil which costs $4/kg was combined with 14kg of canola which costs $1/kg. Find the cost per kg of mixture.
what did the Muslims gain from the crusaders ?