Export Matrix Data to Excel - Data type Problem
Hi there,
I'm having difficulties to get rid of the "green flag"(numeric data return as text) in Excel! My Matrix returns a table which consists of both varchar and numeric data.
e.g.
number=0 | number=1 | number=0
Field1a | Field1b | Field1c
yes | 1.0 | no
no | 2.2 | yes
I've got format expression to convert the text to float (F) if number=1 and nothing ("") if number=0.
If i export the data to Excel, the numeric data will return as text instead of number and i need to convert that column to number manually each time. Anything i could do to get rid of that? Please advise...
Many thanks,
Julez
[820 byte] By [julez] at [2007-12-22] 