Column format from text to numeric

[Tommy]

Dear All,

I have a data column in string format. The data shows "000012345" presenting
123.45. My question is how can i convert it from the string format to
numeric format so that I can make some calculations on it.

Thank you!!

 

[Arvin Meyer [MVP]]

?CDbl("000012345")/100
123.45

or in a query:

Select CDbl([MyStringField])/100 As Converted From My Table;