From time to time, I have had to export files from a text document into excel in order to manipulate the figures. On several occasions I have been slowed down because the data is still being read as text instead of figure even after I have reformatted it.

I have never had much joy in exporting documents from one format to another either. Sounds like you are having more luck than I do, sorry I can't help you here.

I'm really not sure what your problem is. Do you mean you are taking a list of say prices from Word into Excel to run a sum of them and its not working because its still text? I've never really exported between much but it would seem to me its more than a formatting problem and perhaps something different. Even as numbers they are still text, just text that is given a variable so that you can run equations on them...

I am trying to figure it out as well so I'm a little lost here. Can you give us an example of what you are taking from one and moving to the other?

If you import as a .csv (comma separated value) file then it will recognize them better. Are you creating it as a text file in note pad or is it somewhere else?

Have you tried to copy and paste instead of importing? You can copy and paste and it will recognize the number as a number. There are a lot of places on the web that you can find Excel help.

George

I think csv is the only way I have gotten it to work myself but it was still a pain if I forgot that one (csv) and tried using another. Or if I fully did not even do the "special paste" too.