View Single Post
  #6  
Old April 24th, 2004, 07:06 PM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default Leading Zeroes

I agree, plus if you use the method I posted you have import it into a
workbook,
I just wanted to show that there is way, albeit less useful.
--

Regards,

Peo Sjoblom

"David McRitchie" wrote in message
...
Hi Peo,
Thanks for reiterating that, hadn't really paid enough
attention to your answer or to the options on the menu
even though I say one of the best ways to learn Excel
is to go through the menus.

In any case a direct open of a file is easier, and that
includes double-clicking to open so if the formula is
picked up automatically from a .csv file that would
certain make computer generated data from say
mainframes a lot easier to read into Excel.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Peo Sjoblom" wrote...
No, you are wrong. No need to change the file extension.
Try it.. Do dataimport external dataimport data,
in the dialogue box files of type select all files or type *.*
find the csv file and open it and the text import wizard will
start.