Hello all

I need to convert a string field in a numer field

Is that possible?

Thank you in advance for answers

Ok thank you but another step now hehe

In the fild i have this formula

(toNumber ("0"+Cstr({tablename.fieldname})))

The tablename.fieldname is a number like 1234

I've put cstr command because i need to put a 0 before him so he can be seen on print like 01234
I dont know why the Cstr command transform a field number in a string field but with toNumber i can transform back to number

The problem is that now the field reconverted to number suppress the initial 0 that i've put with the Cstr command

There's a way to see that 0?

Thank you by now

Not working, i've tryed

But i've found the solution by checking display current symbol and put the 0 instead of money symbol (this solution had not worked until yesterdary and i've tried many many times )

Thank you for answers

Half way to solution maybe

with

cstr ("0"+(totext({@tablename_fieldname},0)))

From a field 12345 i can obtani 012.345

How can i suppress the "."?

Best regards

Same result the 1235 become 012.345 but the "." is still there