Tips for its spread sheet of Excel
We will place here many tips of Excel and spread sheets of models for download
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!
Commentaries:
Tabelinha is missed…
it is legal, more it would be good if it had one that transforms dollar and Real…
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
It sees more:
To write a date for extensiveYou can use the VExtenso for many finalizades, one of them to write a date for extensive. Although… |
Extensive value for very long? It breaks the line!The times the VExtenso can exceed or overlap other cells, when this if becomes a problem exists one… |
Accounts and expenditures shared with some peopleI created the spread sheet in annex to relate the common expenditures between and my colleagues with which we distribute… |


