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 99999999.99 and specified the numeric option (i.e. not character or date). I have also added #UR XLSF="#0.00" to the comment field but am still getting the same issue. Does anybody know how to get around this? I do NOT want to have to change the Error checking rules in Excel. Many thanks Paul Newton _______________________________________________ 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/[email protected] ** 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.
