Help me changing a string to a number

Fri, 27 Apr 2012 17:52:20 GMT

Hello Guys,

i have a field that i imported called A which is a string and written like that 3,5689548.

i need to convert it to a number & to replace the comma with a dot.

so can anyone help plz

Re: Help me changing a string to a number

CELAMBARASAN — Fri, 27 Apr 2012 18:01:31 GMT

Hi,

Try this,

Num(Num#(FieldName,'###,##',','),'###.##','.')

Celambarasan