Memo to Number field

[luxvivens]

Using Crystal X.
I have a Memo field with a provider number displayed as
'123456'

I would like to make this field a number field to show as
123456

I tried to make the memo field a text field and I did.
I then tried to make the new text field a number and it did not like that.

I wish to strip out the ' both at the beginning and end.

Hope all are safe on the blizzard like day in NorthEast.

 

[luxvivens]

Thanks. You know how all you mavens always instruct us to search on previous posts before submitting an inquiry.

Well, i did that after the fact. Some previous posts by SynapseVampire and LBass helped. I stripped the text field by using the replace function and that did the trick. I was then able to convert the string to a number.