2 of 2 people found this helpful
The issue is a number does not have leading or trailing zeros. So when you covert it to text it does not have them.
You have to add them into the text string.
Let ( [
my_integer = Int ( number_field ) ;
my_fraction = number_field - my_integer ;
my_text = my_integer & Case ( my_fraction = 0 ; ".00" ; Left ( my_fraction & "0" ; 3 ) ) ] ;
Thanks, very nice custom function, thanks works great. have a great week
1 of 1 people found this helpful
my_cent = Int ( number_field * 100 ) ; // use any of Round, Int, Ceiling
Replace ( my_cent ; Length ( my_cent ) - 1 ; 0 ; "." )