Format question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV->Excel Data Problem 1
How to Export Gmail Emails to PST Format? 6
Which is the best MBOX Converter Tool different formats conversion? 5
from date format convert to text format is wrong 2
Data being corrupted by excels automatic date recognition re-forma 6
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Formatting Cells 3
Disable auto (date) format? 3

Back
Top