| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get a txt file to go to excel and have the columns work?
I have gotten the txt file to excel but all the columns are separated but I
can't move them or create charts from them or change the column format. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get a txt file to go to excel and have the columns work?
Try if your numbers are really numbers then (=type() (1=number, 2-text)
if you have a text format use funciotn =value() Eva "Michele" wrote: I have gotten the txt file to excel but all the columns are separated but I can't move them or create charts from them or change the column format. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a file in a work sheet in excel | Excel Discussion (Misc queries) | |||
| Alt+Tab doesn't work to change from excel file to excel file | Excel Discussion (Misc queries) | |||
| Convert Text to Columns with Excel 2007 beta does not work well | Excel Worksheet Functions | |||
| after i save the file my hyperlink does not work in excel 2003 | Excel Worksheet Functions | |||
| trying to open a lotus file in excel, it won't work | Excel Worksheet Functions | |||
Linear Mode
