View Single Post
  #5  
Old April 24th, 2004, 05:50 PM
David McRitchie
external usenet poster
 
Posts: n/a
Default Leading Zeroes

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.