Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to open text file with Excel 2007 Rebeca Excel Discussion (Misc queries) 1 November 23rd 09 10:55 PM
No text search from File|Open in Excel 2007? BrianG[_2_] New Users to Excel 1 June 15th 09 09:02 PM
open text file in Excel and remove columns SLP Excel Discussion (Misc queries) 5 August 14th 08 04:37 PM
open text file with excel George Applegate[_2_] Excel Discussion (Misc queries) 3 April 22nd 08 12:43 PM
open text file in excel George Applegate[_2_] Excel Worksheet Functions 2 April 22nd 08 04:46 AM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"