Stripping out excel formats help

[FANG]

Hi Lars et al

Reading in an XLS which has a cell formatted as "november 7 2009" and a number formatted as "£100,231.05" - All I want is the numbers 40124 and 100231. How do I get it to ignore / strip off the excel formatting

Fang

[larsa]

Hello

If you want the numbers, just read the numbers. Example, XLS.Sheets[0].AsFloat[Col,Row]