• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Drag and Drop TEXT File to EXCEL

S

sudipballa

New Member
Hello All

I download a tabular data from my ERP system to desktop which is saved in .txt

When i drag and drop this file to EXCEL, it neatly arranges itself without giving any prompts. However values like 302.12010 get converted to 302.1201 This is actually a text and I do not want to loose the 0. If i open the txt file using File->Open and then follow the wizard steps, it works fine.

Alternatively, I tried to set the format to TEXT for the whole excel sheet and then drag and drop the file, but it always opens a new excel instance and hence that doesn't help

Any pointers to this?

Thanks in advance
Km
 
Don't drag and drop. But open text file from Excel's Open file menu and specify which columns are imported as text in "Text Import Wizard".
 
You must log in or register to reply here.
Back
Top