FlyerTalk Forums
Page 2 of 2
1
2
Show 40 post(s) from this thread on one page

FlyerTalk Forums (https://www.flyertalk.com/forum/index.php)
-   Travel Technology (https://www.flyertalk.com/forum/travel-technology-169/)
-   -   Foreign currency format in Excel cells (https://www.flyertalk.com/forum/travel-technology/603565-foreign-currency-format-excel-cells.html)

alanh Sep 21, 2006 4:42 pm
Another variation:
Code:
=SUBSTITUTE(TEXT(A1, "€### ##0.00"),".",",")
This formats it, then changes the decimal point to a comma.


All times are GMT -6. The time now is 9:26 am.
Page 2 of 2
1
2
Show 40 post(s) from this thread on one page


This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.