View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
steve_doc steve_doc is offline
external usenet poster
 
Posts: 140
Default convert text file to excel

As far as I am aware txt files do not support formatting

but importing the txt file into Excel via Data/Import External Data/Import
Data
will import your data in a General format.

only problem is if your numeric data has leading 0's - these will be lost

"abugoli" wrote:

The data in my text file, *.txt, contains columns of numbers. each row is
few numbers. is there a way to convert such a file to excel one, keeping the
same format?
thanks a lot,
--
abugoli