If decimals are set to 2, ? TRANSFORM(123456.89,"@$") displays correctly but without the "," separator.
Laurie On 6 October 2014 13:24, Peter Cushing <[email protected]> wrote: > Peter Cushing wrote: > >> Jeff Johnson wrote: >> >>> Peter, I was under the understanding that to print $9,999.99 that you >>> needed 9. Are you saying I only need 8? I always accounted for the "$" at >>> the left. >>> >>> Yeah, sorry forgot about that. Your original format would require 11 >> chars. >> >> >> You can acually get away with 10 but it won't display the $ at the start. > > @23,0 say 123456.89 picture '$$$,$$$.99' && 10 digits without $ > @24,0 say 123456.89 picture '$$$$,$$$.99' && shows $ > @25,0 say 123456.89 picture '$$,$$$.99' && not wide enough - stars > > > Peter > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAMvTR9cU+pMV=r=mfwyb7ombtjiv9-_y5uyhvotbadzdkox...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
