RIGHT function

[dirtmcgirt]

Ok, so here is what I'm trying to do..

I have some fields that are currently formatted as currency. So say for example$185.00 $13.25 & 6.00. What I need to do is change the format of these by dropping the decimal, and adding zeros to the beginning and end of the number so that it ends up a total of 13 characters looking like the following..

$185.00 change to 0000018500000
$13.25 change to 0000001325000
$6.00 change to 0000000600000

I know that I did this before with the RIGHT command, but I can't remember how I did it..

Any suggestions?

[Jrobert73]

Format cells for "custom" with 13 zeros and multiply by 100000

ex. 135
135 formated custom -- 0000000000135
00000000000135*100000=0000013500000