Changing Text into Numbers, using VBA
Hi
one way (non-VBA):
select and empty cell and copy it
- select your imported values
- goto 'Edit - Paste Special' and choose 'Add'
--
Regards
Frank Kabel
Frankfurt, Germany
Cecil wrote:
When importing from a FoxPro database, all the charactors come over
as text. When I try to sum these numbers, it will not sum because
excel thinks they are text. Isn't there a way to convert all these
to numbers through vba?
|