Excel open file as text

A

alexseys

is there a way to tell excel when opening new file, treat is as text?
i.e. even if there is a 00000 value leave it the way it is
 
G

Gord Dibben

New workbooks don't have values.

Do you mean open a *.txt file in Excel and have values treated as Text.

Open the *.txt file and the Text Import Wizard will pop up.

In Step 3 select all columns(Shift + click).......Column Data Format>Text.

Finish.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel freezing after sharing document by Email 0
Excel keeps asking me if I want to save an already saved file. 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Name of file opened, being viewed 2
Unreadable text when viewing organization chart in Web version of Visio 365 0
Working outlook via vba code with xlsx - error 0
Embedded Excel into Word with Tables 0
Word document showing gobbledegook 0

Top