var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Remove decimal in report
I have a formatting issue I need help with. I'm designing a report which will be printed on a pre-printed form. I'm forced to use the pre-print due to insurance co requirements (they scan the form).
Basically, it's a list of itemized charges. The charges cannot contain decimals or $.
So $999.99 must display as 999 99
I've tried "=Str([Line1Charge])" then several custom formats, but I can't seem to get rid of the decimal.
I must be retarded. Any suggestions are appreciated.
You could pull it as a string and replace the decimal with a space using Replace()
Yep, I'm retarded today.
=Str([Line1Charge]*100) worked too.