FlyerTalk Forums

FlyerTalk Forums (https://www.flyertalk.com/forum/index.php)
-   oneworld (https://www.flyertalk.com/forum/oneworld-411/)
-   -   Help with XLS RTW Pricing Spreadsheet (https://www.flyertalk.com/forum/oneworld/608220-help-xls-rtw-pricing-spreadsheet.html)

MiamiPrep Oct 2, 2006 1:26 pm
Help with XLS RTW Pricing Spreadsheet
 
Latest pricing spreadsheets
WearyBizTrvlr - http://qsi.cc/users/wbt/RTW%20Fares.xls


When I try to load this spreadsheet with Quattro Pro, I get an error message:

: Cannot load a formula, only its value. Modified cells will be displayed in red. continue?

The red cell for OW Fares is E2. (To the right of "Currency" line).

What is the formula for E2? Thanks.

Viajero Oct 2, 2006 1:53 pm
Originally Posted by MiamiPrep
...What is the formula for E2?
="exchange rates updated " & TEXT( fxDate;"dd-mmm-yyyy")

The date format above is taken from my system default, yours will probably differ.


All times are GMT -6. The time now is 7:22 pm.


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