I'm needing a rule to convert currency values to a 11 digit padded number. Examples are:
$265.39 to 00000026539
$43.90 to 00000004390
$765.00 to 00000076500
I thought the padded number rule would work but apparently with the $ sign and (.) in the data, it's not.
Any ideas?