Converting text to 2 decimal places

[lwilt]

I'm trying to convert a text field to a numeric field with 2 decimal places but it won't work. Please Help



I tried String:Format(CDec([Field],"0.00")

[JoeM]

When you apply the FORMAT function, you are converting it back to a text/string value. So you are basically undoing what you are trying to do by using the CDEC function (you are going from Text to Decimal back to Text).

If you want to convert a string to a number, I usually do it like this:
CDbl([Field])

If you want to change the display so that 2 decimals are shown (i.e. on a Form, Report, Query, etc), you would just change the Format property of that calculated field to show 2 decimals.