M
Miquel Burns
The web application I'm working has output for Excel sheets, but the
data from the data is sometimes changed to a date format (And results in
a '#######' cell each time this happens, and the value is not the same
as what was retrieved from the database so that bit of data becomes
worthless).
Question, how to you set the format to plain text so Excel doesn't
reformat certain values to something like date/time and mess up the data
the user recieves?
(And how to format a column to currency would also be useful)
VBScript, the OWC from Office 2000
data from the data is sometimes changed to a date format (And results in
a '#######' cell each time this happens, and the value is not the same
as what was retrieved from the database so that bit of data becomes
worthless).
Question, how to you set the format to plain text so Excel doesn't
reformat certain values to something like date/time and mess up the data
the user recieves?
(And how to format a column to currency would also be useful)
VBScript, the OWC from Office 2000