Hi, I'm trying to figure out such an issue: I have this data:
A182: "01/10/10" G182: "=A182" A183: "01/03/11" G182: "=A183" A184: "01/04/11" G182: "=A184" That is, cell A182 contains "01/01/01", whereas cell G182 contains "=A182" and so on. When I convert this file to a text format, I get this: 01/10/10 40,452 01/03/10 40,603 01/04/10 40,634 That is, the formula/reference is converted to some weird value To see exactly what I mean, here's the excel file and the resulting .txt: http://files.dmitriid.com/tika/excel.xls http://files.dmitriid.com/tika/out.txt Any idea how to work around this? Thank you!
