The safest way it to use a separate column to designate the relevant
currency, then you can apply appropriate conditions based on that column.
You could, of course, put your Euros and Pesos in different column if you
prefer that approach.
--
David Biddulph

"hsfmnl" wrote in message
...
How do we apply the Philippine Peso (e.g. Php 1,450.00) and Euro decimal
(e.g. ?1.450,00) in the same spreadsheet?