Help to get decimal numbers in char datatype field

[Naga]

Hello,

Need some help with the below request. I tried to use tonumber() formula that is not getting the expected result. 

I have a string field, which holds a number and I need to add 2 decimal places only for the records that doesn't have any decimal and the rest to be kept as is.

Input	Output
99.67	99.67
104	104.00
101	101.00
97.44	97.44

Thanks
Naga

[messi007 · Accepted solution]

@Naga,

Please see below:

Attached the workflow.

Hope this helps!

Regards.

[Naga]

Hi @messi007 ,

Fantastic and Thanks for your quick response...it worked very well.

Thanks

Naga

[messi007]

@Naga,

Happy to help and happy analyzing 🙂

Best Regards,