Format question

L

Luis

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?
 
J

Jim Rech

If i format a cell as Text and then write one of these values there's no
That's the only workaround I believe. There is no way to turn off Excel's
"helpfulness".

--
Jim
| 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?
 
Top