Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort of format Question | Excel Worksheet Functions | |||
Conditional Format Question | Excel Worksheet Functions | |||
Date Format Question | Excel Discussion (Misc queries) | |||
Format Question Please | Excel Discussion (Misc queries) | |||
Trailing Space / Format Question | Excel Discussion (Misc queries) |