Convert Text to Number Excel in LotusScript

Can anyone guide me on how do i convert a Text To Number? I've been trying to use xlapp.selection.FormatNumber = "#,##0.00" But won't work because the exported column turns out to be in a text format. thanks for your help, really appreciate 开发者_如何学JAVAit.

-Edit I am using lotusscript to export a view into excel. My dilemma is that the exported column containing Numbers turns out to be exported as Text and Needs to be converted to number first before i can use xlapp.selection.FormatNumber = "#,##0.00" to format it. I would like to know the syntax to convert the column into number by means of using lotusscript.

What about CDec ?

To convert a column value into a number in LotusScript, use the CDbl function.