Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an application that generates a file. I can give any kind of extension
name to this file generated. I have full control on output generated in this file. Meaning, I can put quotes, single qute, tab, etc anywhere I want. My objective is to open up this file in Excel. When I do that, some text like "00010010" ends up becoming 10010. How do I avoid that from happening. Note that since the file extension is already a ".xls" or a ".csv", Excel opens it up right away, rather than going through a formatting steps that I would normally go through for opening up a ".txt" file. What I have tried so far is 1) "00010010" 2) '00010010' 3) '00010010 None of these produces the desired result. I would appreciate any help provided. thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error message when using Excel to open text file | Excel Discussion (Misc queries) | |||
Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
Excel keeps converting text to date format | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) |