total1 = 775022.500000009total2 = 45022.26
total3 = 5000.33
total4 = 800.25
do you have any lotus script code that will convert:
total1 to 77,5022.50
total2 to 45,022.26
total3 to 5,000.33
total4 to 800.25
total1 = 775022.500000009total2 = 45022.26
total3 = 5000.33
total4 = 800.25
do you have any lotus script code that will convert:
total1 to 77,5022.50
total2 to 45,022.26
total3 to 5,000.33
total4 to 800.25
Subject: Converting double data types
Hi,
I think you dont need to convert!
Write the values in a Currency field and set
Thousand delimiter
…
it should work! It als works for me!
Hope this helps
Thomas Balatka
Subject: Format(total1, “Currency”) or for no currency symbol Format(total1, “#,##0.00”)
Subject: RE: Format(total1, “Currency”) or for no currency symbol Format(total1, “#,##0.00”)
This helped me today! THANKS BILL!!!