Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 8th 11, 09:07 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2011
Posts: 1
Default Importing from a Notepad file

I want to import data from a comma separated Notepad file. When I import into Excel I find that the leading zeroes are dropped and I don't want this to happen. I have some fields that should be "000" not "0".

Is there a way to import without losing all these zeroes?

  #2   Report Post  
Old December 9th 11, 12:42 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default Importing from a Notepad file

When youi Import or open a *.txt file the Text Wiizard will pop up and
in Step 3 under Column Data Format you can select Text.

Leading zeros will be held.


Gord



On Thu, 8 Dec 2011 12:07:53 -0800 (PST),
wrote:

I want to import data from a comma separated Notepad file. When I import into Excel I find that the leading zeroes are dropped and I don't want this to happen. I have some fields that should be "000" not "0".

Is there a way to import without losing all these zeroes?

  #3   Report Post  
Old December 9th 11, 12:49 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default Importing from a Notepad file

You did say a comma separated file which is most likely *.csv

Change the csv extension to txt then import or open directly in Excel.


Gord

On Thu, 08 Dec 2011 15:42:25 -0800, Gord Dibben
wrote:

When youi Import or open a *.txt file the Text Wiizard will pop up and
in Step 3 under Column Data Format you can select Text.

Leading zeros will be held.


Gord



On Thu, 8 Dec 2011 12:07:53 -0800 (PST),
wrote:

I want to import data from a comma separated Notepad file. When I import into Excel I find that the leading zeroes are dropped and I don't want this to happen. I have some fields that should be "000" not "0".

Is there a way to import without losing all these zeroes?



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
Notepad or .txt file to excel nathan Excel Worksheet Functions 3 December 1st 09 10:44 PM
Writing to notepad file Jeff Excel Discussion (Misc queries) 2 October 23rd 06 03:16 AM
importing from notepad trouble left_blank Excel Discussion (Misc queries) 3 May 6th 06 02:17 AM
Export notepad file to Excel Carrie Excel Discussion (Misc queries) 2 February 2nd 06 06:36 PM
copy excell file to a CSV file and than to Notepad need to know bob Excel Discussion (Misc queries) 0 August 23rd 05 07:27 PM


All times are GMT +1. The time now is 07:39 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017