"TONUMBER" - syntax problems ?? !!

[moron2]

My input type tree is a 38 text/character
field. My output type tree is a database,
defined as a number (38,18)- up to 18 decimal
places.
No matter what I've tried,,, I only get 4 decimal places (i think a default).
Here's some of the samples I tried.
=TONUMBER(myvalue Column:In1,"{#[,]### [+'.'+MinDigits(0)+ '##'+ MaxDigits(18)+]}")
=TONUMBER(myvalue Column:In1,"{###['.'## + maxdigits(28)]T+'K'-}")


thanks in advance to anyone who has some suggestions...

Kris

 

[janhes]

Output field should be defined an number decimal max size 38 number of decimal places min 0 max 18 separators yes format #[,]###.[##]
In the rule just use =TONUMBER(myvalue Column:In1)

So an input of 123456789.123456789 gives a number of 123456789.123456789

 

[janhes]

Ah but you have formatted input so
=TONUMBER("123,456,789.123456781","{#[',']###['.'##18]}")