FormatNumber as currency - but need a decimal
Posted: Tue Dec 29, 2015 12:56 pm
Question - is there an easy way to use "FormatNumber" and take a fixed length field such as 00053084 and convert it to $530.84 ?
What I'm trying to do is take a number that is in a fixed-length record and display it with the decimal before the rightmost two digits. Everything I see in the FormatNumber pattern shows me how to add in a ".00" if it's not there, or perform rounding if the number already contains a decimal. In this case there is no decimal but the #.## pattern is implied with the rightmost two digits.
Is there a way to invoke FormatNumber on this or do I need to come up with a slightly more elaborate function to take the number convert it to a string and chop it up for display accordingly?
Thanks!
Ryan
What I'm trying to do is take a number that is in a fixed-length record and display it with the decimal before the rightmost two digits. Everything I see in the FormatNumber pattern shows me how to add in a ".00" if it's not there, or perform rounding if the number already contains a decimal. In this case there is no decimal but the #.## pattern is implied with the rightmost two digits.
Is there a way to invoke FormatNumber on this or do I need to come up with a slightly more elaborate function to take the number convert it to a string and chop it up for display accordingly?
Thanks!
Ryan