Hi all,
Hope this isn't too silly a question.
I have a currency field in my database that needs to be formatted in a specific manner for output to a 3rd party system.
The number needs to include 8 digits with trailing or leading zeroes.
Eg.
$585.00 = 00058500
$585.45 = 00058545
If anyone could help me out that would be awesome.
Thanks,
Andrew
Hope this isn't too silly a question.
I have a currency field in my database that needs to be formatted in a specific manner for output to a 3rd party system.
The number needs to include 8 digits with trailing or leading zeroes.
Eg.
$585.00 = 00058500
$585.45 = 00058545
If anyone could help me out that would be awesome.
Thanks,
Andrew