convert text file to excel
 

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

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

convert text file to excel
 

do File=Open, this will open the text import wizard.

select delimited or fix width as appropriate. If the cells contain leading
zeros, on the last dialog in the wizard (3rd dialog I believe), you can
specify how the data in that column is to be treated. Selectin text will
cause the data to be treated as text and not alter the formatting (or remove
leading zeros), but the data will be text.

--
Regards,
Tom Ogilvy


"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