Column format from text to numeric

  • Thread starter Thread starter Tommy
  • Start date Start date
T

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!!
 
?CDbl("000012345")/100
123.45

or in a query:

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