Posted to microsoft.public.excel.programming

Cecil[_3_] Cecil[_3_] is offline

external usenet poster

Posts: 1

Changing Text into Numbers, using VBA

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing A Column Of Text numbers To True Numbers: How ?	Robert11[_3_]	New Users to Excel	2	March 4th 09 09:08 PM
Changing text to numbers	Schwimms	Excel Discussion (Misc queries)	0	November 14th 07 04:51 PM
changing numbers in a text string in a new cell	Xhawk57	Excel Discussion (Misc queries)	4	May 16th 07 06:22 PM
Changing numbers to text	Des	Excel Worksheet Functions	1	April 9th 07 08:58 AM
Changing Text to Numbers	Hawksby	Excel Discussion (Misc queries)	3	December 14th 06 06:23 PM

All times are GMT +1. The time now is 02:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us