View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eva Eva is offline
external usenet poster
 
Posts: 197
Default How do I get a txt file to go to excel and have the columns work?

Try if your numbers are really numbers then (=type() (1=number, 2-text)
if you have a text format use funciotn =value()
Eva

"Michele" wrote:

I have gotten the txt file to excel but all the columns are separated but I
can't move them or create charts from them or change the column format.