Gene, If one allows the dollar sign as input to VAL with a minus in front of it the result is a zero value.
Joe On Tue, Jan 27, 2015 at 3:21 PM, Stephen Russell <[email protected]> wrote: > On Tue, Jan 27, 2015 at 1:02 PM, Joe Yoder <[email protected]> wrote: > > > In my case I'm importing a .CSV file into text fields. It would be > > interesting to see what happens if I configure the receiving structure as > > currency instead. My suspicion is that I'll still need to deal with the > > debits in a special way. > > -------------------- > > > > Yeah that currency is a BITCH for us. Just maintaining the conversion > table by week for Sterling, Euro, CA Dollars and others thrown in there for > grins and giggles. > > > > -- > Stephen Russell > Sr. Analyst > Ring Container Technology > Oakland TN > > 901.246-0159 cell > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [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/cabqednukvxq83mvu140qjs5+rhvroiplhdezf9zwl8i5x-x...@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.
