>This may sound like a dumb question but can any one tell me how to test for the type of data comming out of excel. i.e. if the cell is text or numeric
In Visual FoxPro, you can use the type() or vartype() function. I think this should work for values obtained from Excel, too.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)