Skip to Content
0
Former Member
Sep 17, 2007 at 06:48 PM

last one today... convert number to a string? or other way to format??

19 Views

Post Author: cmainard

CA Forum: Formula

I have a price field which I need to strip the decimal from

I used the formula below, which worked but rounded my price down to 2 "decimals" if the price is 16.0362 that is what I need to show, as 160362 in the resultant data.

Replace (totext({MoxyAllocation.AllocPrice}), ".", "")

this gave me: 1604