Typecast

[priya_anthony]

Hi experts
Need your help
What am i looking out is to type cast the data i.e numeric to string
i.e i retrieve the data as "001" from the database which is numeric and when i type cast it to a string it gives only 1
i.e
Str(oPersonHelp.Value(R, C)---'it contains the value 001)
i want the same data i.e 001 instead of 1

kindly help

 

[BrianB]

The numeric data is not 001 - it is just formatted to look that way.
So you need to format the string the way you want with something like :-

Dim MyText as string
MyText = Format(oPersonHelp.Cells(R, C).Value,"000")

 

[Norie]

Use Text instead of Value.

That will return the value as it is formatted, if that's what you want.