Currency Format with 2 or 3 Decimal Places

[JohnHarkins]

I can format US currency as having two or three decimal places (the default being two, of course). However, I have the situation where thhe values for stamps are either whole cents or half-pennies. I'd like to display the numbers as, for example, $0.34 (or 34c, where c is the cents sign) and $0.345 or $0.34 5, where the 5 is in superscript format when the value has a half-cent component. If I need to

Is there any convenient way to format these values?

Thanks,

John Harkins

 

[pdldavis]

Hi, this is not exactly formatting per se, but you could do something like this:

Price: IIf(Len([value])=3,[value] & "c","$" & Mid([value],1,3) & " " & "5&quot

It assumes you are working with 3 or 4 characters - .34 or .345 for example. The above would display .34c or $.34 5

Hope that helps.