I admit I just did ?VAL(-123). I did not try with a negative currency value. But Stephen's question didn't format his test string with a minus sign either. As Gene points out, reading the fine manual should eliminate any ambiguity. :-)
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Gene Wirchenko Sent: Tuesday, January 27, 2015 1:35 PM To: [email protected] Subject: Re: function to convert currency formated data in a text field At 08:41 2015-01-27, Stephen Russell <[email protected]> wrote: >Will VAL() register a negative amount ($123.45) as -123.45? It did not when I checked it on my system (VFP 9). I got zero. This is per the docs: "VAL( ) returns 0 if the first character of the character expression is not a number, a dollar sign ($), a plus sign (+), or minus sign (-)." Sincerely, Gene Wirchenko _______________________________________________ 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/cy1pr10mb0218dabed0914ecd5607635fd2...@cy1pr10mb0218.namprd10.prod.outlook.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.
