How do i convert my long string text dollars into positive money numbers? (The negative conversion works.)

[FinancePerson]

Good morning All,

      I am working on a file from another company. The money represented comes over in a text format 16 characters long.

Ex. 0000000000013054

I can get the negative numbers to load with the following script:

if(left(trim([@43:59]),1)='-',num#(right([@43:59],14))/-100,num#(trim([@43:59]))/100) as pay_amount

but the positive numbers wont pull through. 

Desired result from ex above: $130.54 

[hic · Accepted solution]

Try

Money(Evaluate([@43:59])) as pay_amount