I'm using UDE to export a recordset to Excel. Everything works except that 'number' text like phone numbers are exported as scientific notation numbers when they have more than 10 digits. They can be reformatted in Excel but this is a bother for the client. Is there a way round this?
Phone numbers with a zero in front are being scrambled with a *minus* in front!
Perhaps the fields causing problems in the recordset could have a CONCAT_WS operator so that a single quote is appended onto these "numbers-that-are-text" fields. Bit of a long way round though.
The numbers are all in MySQL varchar format I've tried wrapping the fields in the recordset like so: SELECT *, CONCAT('"', postcode, '"') AS postcodex , CONCAT('"', tel, '"') AS telx, ...etc
When I test the recordset in Dreamweaver it wraps the numbers in quotes e.g. "021 1234567" but if I test the page on my local dev server XAMPP, it breaks with an error: Parse error: syntax error, unexpected '', postcode, '' (T_CONSTANT_ENCAPSED_STRING) ...etc