Format question
 

Hello.
I have a Web application that exports information to Excel. The problem is
that some fields have values like "ABR1", "ABR2", "JAN1", etc.
When Excel opens these values are converted to Date format. If i format a
cell as Text and then write one of these values there's no problem.
Is there any way to force Excel to not to autoformat cells?

If i format a cell as Text and then write one of these values there's no
problem.

That's the only workaround I believe. There is no way to turn off Excel's
"helpfulness".

--
Jim
"Luis" wrote in message
...
| Hello.
| I have a Web application that exports information to Excel. The problem is
| that some fields have values like "ABR1", "ABR2", "JAN1", etc.
| When Excel opens these values are converted to Date format. If i format a
| cell as Text and then write one of these values there's no problem.
| Is there any way to force Excel to not to autoformat cells?