ExcelBanter - Excel open file as text

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Excel open file as text (https://www.excelbanter.com/new-users-excel/250826-excel-open-file-text.html)

Excel open file as text

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

Gord Dibben

Excel open file as text

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 FormatText.

Finish.

Gord Dibben MS Excel MVP

On Fri, 11 Dec 2009 11:52:38 -0800 (PST), "
wrote:

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

All times are GMT +1. The time now is 08:16 PM.