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

0.425 in simplest form
please help, will reward Suppose that there are two types of tickets to a show: advance and same-day. The combined cost of one advance ticket and one same-day t
Who is speaking at the end of the poem The Lady of Shalott
HURRYYYY 15 POINTSHow is the graph of y= -1/3x related to its parent function, y= 1/x?A. It is horizontally stretched by a factor of 3 and reflected over the x-
Which taxon contains only one kind of organism
Identify how a hormone molecule performs its function
A fish tank needs 10 gallons of water in order to fill it up. How many quarts are in a 10 gallon fish tank?
SCREENTSHOT INCLUDED IM TIMED What is the value of x? Enter your answer in the box.
how many ATP's are required to start glycolysis anf how many ATP's are produced?
Which statement is true about AC? A). The electrons move back and forth B). The +/- polarity is constant C). It is most common in portable devices D). It can