Tips for its spread sheet of Excel

Dollar X Real: comma and point, or point and comma?

Real dollar/: comma and point, or point and comma?

 

Excel for standard uses the regional configurations of the Windows to determine as it will show the numbers with decimal and separate houses to the thousands. In Brazil, we use the comma for separator decimal, and optionally the point as separating of thousand. Being thus to express, for example, the monthly cost to keep the site of the VExtenso in air, we use:

R$ 19,90

In the United States the separator of decimal houses is the point, and the comma is used in the separation of the thousands. Being thus the same value above, in dollar in the quotation of today, they seiram thus express:

US$ 12.06

It compares:

Dollar	Reals
US$ 2,345.67	R$ 2,345, 67

 

I tried to search a solution to show both the values in one same spread sheet, and discovered that it is not possible without the aid of functions and much gambiarra. Happily of pra to decide this with two functions only: TO SUBSTITUTE and TEXT.

The formula you to copy and glue is the following one:

= " US$ “& TO SUBSTITUTE (TO SUBSTITUTE (TO SUBSTITUTE (TEXT (C3; “#.##0,00”); ”, “; “*”); ”. “; ”, “); “*”; ”. “)

Placing the correct exhibition of the values in Dollar in its spread sheet of Excel you please the Greeks, troianos and Americans!

In 12/Abr/2010 - 12:20 sprung from the same father and mother wrote:
Tabelinha is missed…

In 13/Out/2008 - 10:50 emerson wrote:
it is legal, more it would be good if it had one that transforms dollar and Real…

In 22/Ago/2008 - MCembra 09:33 wrote:
I already use vextenso (), and am excellent, me the o biggest value this in the tips of the site. He gains yourself very with this aid. congratulations