Hi all,
I need to convert a field to text format which consists of numbers while sending it to excel in QV9. For which i have used text() function and the values preceding with zeros are only converted to text format, but the values starting other than zeros are stored in General format and not stored as text format in the excel. Could anyone please let me know on how to convert the numbers from a field to text when sending it to excel in QV9.
I have given a sample data for which i have to convert the numbers to text format in the excel.I tried the same in QV11 and the numbers are converting to text without any issues. But i need this conversion in QV9.
Thanks
Table:
LOAD * INLINE [
Name, Value
AAA, 00010
BBB, 00020
CCC, 3020567
DDD, 34567
EEE, 56784
];
