Thread: Format question
View Single Post
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

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?