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

find the sum. write each mixed number in simplest form 4 7/8 + 5 1/4
Factor the expression. If the expression cannot be factored, say so.
What's 5 divided by x squared explain
Thelma spent 1/6 of her weekly allowance on dog toys.  1/4 on a dog collar and 1/3 on dog food.  What fraction of her weekly allowance is left
What is the creepiest sounding scale? What scale would u use for writing creepy music in other words
Thelma spent 1/6 of her weekly allowance on dog toys.  1/4 on a dog collar and 1/3 on dog food.  What fraction of her weekly allowance is left
What's 5 divided by x squared explain
What all the multiples of 81?
What's 5 divided by x squared explain
A blue rope is 3 times the length as a red rope. A green rope is 5 times as log as the blue rope of the total length of all 3 ropes equals 508.25m what is the l