Originally posted by: SystemAdmin

We need to display a decimal value that is stored (unfortunately) in a text type field.
The requirement is that this is always displayed with three decimal digits, defaulting to 0 (zero).
The input is a number, so I guess that I'll need some kind of = text(tonumber(<value>,"{formatstring}")) construction.
I can't get the formatstring to work, most of the time my input is simply discarded.
So what is the correct formatstring?
Any help would be much apprectiated.

Examples of the required transformation: 123 -> 123.000 and 4,56 -> 4,560
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: paul.brett

I think you need a rule such as this:

=FROMNUMBER(In1,"{#','###'.'3##3}")

Please see example.

Paul.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Hi Paul,
Your lead did the trick.
Ultimately "{####'.'3##3}" is the format that works for us, as we don't use a thousands-separator, but your example helped us to understand this cryptic mechanism.
Thanks again for such a quick solution.
Rolf
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender