Skip to Content
0
Former Member
Aug 21, 2007 at 09:23 AM

How to format a string which is representing an amount

9 Views

Hi Experts,

My question is : Do we have any function which can correctly format an string which is storing an amount.

For example:

Input String : '1234567'

Expected outpt : '1.234.456,00'

Input String : '1.23456.78,2586'

Expected outpt : '12.345.678,26'

Requirement is like :

there should be exectly 3 digits between consecutive '.' ','

if there are more then 2 digits after decimal point , the number should be rounded off.