No offence Frank, but all the advice I have gotten from you has been shall we say lame. There is 20 ways to manually do the text to numbers thing, I can do that. I am looking to do it with vba so I don't have to do it manually. Thanks anyway

----- Frank Kabel wrote: ----

H
one way (non-VBA)
select and empty cell and copy i
- select your imported value
- goto 'Edit - Paste Special' and choose 'Add

--
Regard
Frank Kabe
Frankfurt, German


Cecil wrote
When importing from a FoxPro database, all the charactors come ove
as text. When I try to sum these numbers, it will not sum becaus
excel thinks they are text. Isn't there a way to convert all thes
to numbers through vba?