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

if a baking tray is 700mm by 600mm, how many of 25cm in diameter can fit into the baking tray?
how do you convert mol dm-3 to gdm-3 and vice versa
What is the base of Apothecary
Compare the various effects that alcohol has on the mind and body at two different blood alcohol concentrations.
Complete the following statements by writing the missing word (s). 16. If two lines intersect, then their intersection is exactly ________________. 17. ________
How do I Stargaze? Please help :)
a map has a scale of 2 in : 25 mi. The map shows a highway is 31 inches long. how long is the actual highway?
What is an object with a very high resistance classified as?
what are the effects of boiling sulfuric acid?
and what is this A rock band has 5 members, and two fiths of the members play string instruments. Also, 0.4 of the members sing. Does the band have the same num