Convert number stored as text to number

grchristin · Post by **grchristin** » Tue Jun 01, 2010 6:46 am

How can I convert a number stored as text to a number. I can do it in Excel but can't figure out a simple way to do it using XLSReadWriteII4.

For now I'm just using

XLS.Sheet[0].AsFloat[i,z] := StrToFloat(StringReplace(XLS.Sheet[0].asString[i,z], ',','',[rfReplaceAll]));

and it works.

I wonder it there's another way.