suppress leading zero

[GDI]

How can I suppress leading zeros from a number? Is there an easy function that I can use?
Thanks,
David

 

[onpnt]

try this out
dim var111
var111 = "000000321"
KillZeros = CStr(CInt(var111))
alert KillZeros You cannot mandate productivity, you must provide the tools to let people become their best.
-Steve Jobs
admin@onpntwebdesigns.com

 

[GDI]

This is the error im getting...
Type mismatch: 'CInt'

this is my statement I'm using...
CStr(CInt(Myretail))

I can make the Data Type of the field and still get the error ...
Character
Integer
Float

Still lost,
David

 

[sfvb]

To find out what data type it is use the TypeName function.
msgbox("var111 is a " & TypeName(var111) & " data type&quot

 

[GDI]

It showed "String"

 

[sfvb]

Are any of the leading zeroes actual the letter "O"?

 

[GDI]

The leading zeros are 0(zero) and not o(letter)

 

[sfvb]

It was worth a shot. About the only thing I can think of is to try it using a larger numeric data type. Hopeful one of these will work.

KillZeros = CStr(CLng(var111))
KillZeros = CStr(CSng(var111))
KillZeros = CStr(CDbl(var111))