Numeric values in Excel generated by XFRX

Hi all I have a VFP report and am using XFRX to create an Excel sheet. The numeric vales in the report are flagged up as The number in this cell is formatted as text or preceded by an apostrophe. In the Format tab of the Field Properties I have set the format expression as .99 and

Re: Numeric values in Excel generated by XFRX

Paul Newton wrote: Hi all I have a VFP report and am using XFRX to create an Excel sheet. The numeric vales in the report are flagged up as The number in this cell is formatted as text or preceded by an apostrophe. In the Format tab of the Field Properties I have set the format expression as

Rounding

Hi folk What is the best way to round the following myam=696/26 I want Myam to be 26.76 -- Kind regards Sytze de Boer Kiss Software --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

Re: Rounding

On 10 January 2014 19:55, Sytze de Boer sytze.k...@gmail.com wrote: Hi folk What is the best way to round the following myam=696/26 I want Myam to be 26.76 Hi Sytze, how about: FLOOR(696/26*100)/100 You might want to try a few other values! -- Paul

Preprocessor directives in a form

Hi all, I have a form that used preprocessor directives. For example: #DEFINE LENGTH 10 It seems that no matter where I put them in my form, I get not found errors when my code tries to reference the constant that I've defined. Where should these go in my form's code so they're

RE: Preprocessor directives in a form

On the VFP system Form menu there's an option to set an include file at the form level. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John J. Mihaljevic Sent: Friday, January 10, 2014 3:13 PM To: profoxt...@leafe.com Subject: Preprocessor

Re: Rounding

Hi Thanks Paul I also found myam=VAL(TRANSFORM(696/26,#.##)) On Sat, Jan 11, 2014 at 9:02 AM, Paul Hill paulroberth...@gmail.com wrote: On 10 January 2014 19:55, Sytze de Boer sytze.k...@gmail.com wrote: Hi folk What is the best way to round the following myam=696/26 I want

Re: Rounding

+1 for Transform! After I discovered the power of the Transform(), my Foxlife was never the same. :) Mike Copeland Original Message Subject: Re: Rounding From: Sytze de Boer sytze.k...@gmail.com To: profoxt...@leafe.com Date: 1/10/2014 3:25 PM Hi Thanks Paul I also found

RE: Rounding

Technically that's not rounding; It's truncating the value to the 2nd decimal place. Rounding to 2 digits of precision for that result should be 26.77. So if you want rounding to two places, you should use ROUND(696/26,2). Otherwise either the FLOOR or the TRANSFORM will do the trick. And