I'd like to grab your attention: you have to deal with All the values saved to a DataTable sheet as Character or String.
1-if you have the number of passengers as 3 you can retrieve this value by Cint(DataTable("Passengers"))
2-if you have travel date as 12/7/2005 you can retrieve this value by DateValue(DataTable("TravelDT"))
I faced some problems with these values, hope you will get benefits of this information.
Just one more FYI that when you store large numeric values into the cell then QTP converts it into exponents. For ex "12345678901234567890" would change to some thing like "1.23456789012346E+018". So if you want to avoid that then while filling the value add a "'" single qoute sign before the value. Adding a "'" before the value tells that the value should be treated as text and no auto conversion should be done. So when you read the value you will get "12345678901234567890" and NOT "'12345678901234567890"