Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to convert De-limited text file to excel
I have a text file de-limited with tab. I need to convert the same file to
excel and use chart options to draw a graph. Though i am able to import the text file in to excel file i am unable to draw graph with that data. Please help me do it. |
#2
|
|||
|
|||
Maybe the 'numbers' in the data are being seen as text, try entering 1
anywhere on the sheet and copying it. Then highlight the 'numbers' and do EditPaste special...Values+Multiply This should kick the text numbers to actual ones and you should then be able to chart it -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Venkatesh S" <Venkatesh wrote in message ... I have a text file de-limited with tab. I need to convert the same file to excel and use chart options to draw a graph. Though i am able to import the text file in to excel file i am unable to draw graph with that data. Please help me do it. |
#3
|
|||
|
|||
Have you done the <data<text to Column step
"Venkatesh S" wrote: I have a text file de-limited with tab. I need to convert the same file to excel and use chart options to draw a graph. Though i am able to import the text file in to excel file i am unable to draw graph with that data. Please help me do it. |
#4
|
|||
|
|||
Let me save you the trouble of typing 1, then deleting it later. Copy a blank cell,
then do Edit menu Paste Special Values + Add. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Nick Hodge wrote: Maybe the 'numbers' in the data are being seen as text, try entering 1 anywhere on the sheet and copying it. Then highlight the 'numbers' and do EditPaste special...Values+Multiply This should kick the text numbers to actual ones and you should then be able to chart it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I convert a csv file to an Excel file? | Excel Discussion (Misc queries) | |||
How do I convert a Macintosh version 1 excel file to excel 2003 | Excel Discussion (Misc queries) | |||
in Excel 2000 how do I convert text to numbers? | Excel Discussion (Misc queries) | |||
How do I convert cab file to open an Family Budget Excel Template? | Excel Discussion (Misc queries) |