Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers being Auto Date Formatted
I know this question has been asked numerous times. But, wondering if anyone
has found an answer. Numbers in a field, in a tab-delimited text file when opened in Excel are getting auto formatted as DATES. There is no way to turn this off and have information be uploaded, with NO auto formatting of any fields, is that correct? NO, saving as .txt format, then opening excel, then importing, then changing the field to a text value, is NOT an option. Once in a while it is an inconvenience, doing it 100 times a day, is unacceptable performance. I know that Open Office will allow me to do this. Should I then tell my over 200 customers that they should start using open office to open these reports? -- Thanks, kv |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop auto conversion of numbers to a date? | Excel Discussion (Misc queries) | |||
How to auto-increase values in currency formatted cells, by 10%. | Excel Worksheet Functions | |||
Auto copy of Numbers or date | Excel Worksheet Functions | |||
Copied data auto-formatted in Excel | Excel Discussion (Misc queries) | |||
Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) |