Hi,

I need to convert the Numbers as Text entered in a column of a Excel sheet.
Eventhough formatted the Column with the following the Column and each cell
gets formatted but the values in the cell still remains as Number.
NumberFormat = "@"

Found the following function from Excel by running a macro and selecting the
"Data"="Text to Columns" option which converts the Numbers to Text

The VB script of the recorded macro is as follows,
Selection.TextToColumns Destination:=Range("D4"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Tab:=False, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False,
FieldInfo _
:=Array(1, 2), TrailingMinusNumbers:=True

Could someone please advice on what these parameters mean, specially the
"FieldInfo:=Array(1, 2)", don't know from where this array is
generated.
I need the code to be run from VFP.

Also is there any other way to convert the Numbers into Text,
programmetically ?