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

The oven tray is 600mm by 500mm. A cake tin is 25cm in diameter. How many cake tins can jenny fit on the oven tray at one time?
f(x)=x^2-8x+16 x and y intercepts and vertex
Shale is a clastic rock, meaning that it forms when ________________ are squeezed or cemented together (or both).
what are the hardships that new York has to overcome
how did the israelites beliefs differ from the beliefs of most other ancient people
Which sentence uses possessive personal pronouns correctly? A. Yours essay requires some minor revisions. B. Take you're time and drive carefully. C. After
Express the statement below as a fraction in lowest term 80% of American are home owners.
How does Calypso assist Odysseus on his journey home?
Which word is the preposition and which word is the object of the preposition in this sentence? During the raging snowstorm, several cars swerved uncontrollably
What are 3 equivalent ratios for 3/5?