Stripping out excel formats help
Posted: Sat Nov 07, 2009 7:21 pm
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
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