Format column

[Guest]

Hi guys,

Hope you can help. I have a alphanumeic text column where some of the
fields have a leading zero which i want to remove. I can't use the edit -
replace option to remove the zero because other characters of that field
might have a zero too. Is there a way programmatically or by a function to
remove the zero if it is 1st byte? Any help and /or examples would be greatly
appreciated.

 

[Guest]

make the field format a number format rather than text (number,double etc...)

 

[Guest]

That doesn't worked. That was one of the first things i tried. The
file/column field is already coming to me as a text field. It won't convert
to a nukmber cause the field is aplhanumeric. Anyone else???

 

[Guest]

simple macro
check each field
if left(fieldvalue,1)="0" then fieldvalue =
right(fieldvalue,len(feildvalue)-1)