Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Text into Numbers, using VBA
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Text into Numbers, using VBA
Cecil, for a person looking for help your attitude has has been rather shall
we say lame? -- Vasant "cecil" wrote in message ... 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: ----- 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Text into Numbers, using VBA
Sub ffff()
Dim C As Range For Each C In Range("c1:c10") C.NumberFormat = "0" C.Value = C.Value Next End Su -- Message posted from http://www.ExcelForum.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Text into Numbers, using VBA
So
try something like sub foo() dim rng as range dim cell as range set rng = selection for each cell in rng if cell.value<"" cell.numberformat="General" cell.value=cell.value end if next end sub ---- you may consider skipping such words as 'lame' as this won't help you getting advice -- Regards Frank Kabel Frankfurt, Germany cecil wrote: 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: ----- 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing A Column Of Text numbers To True Numbers: How ? | New Users to Excel | |||
Changing text to numbers | Excel Discussion (Misc queries) | |||
changing numbers in a text string in a new cell | Excel Discussion (Misc queries) | |||
Changing numbers to text | Excel Worksheet Functions | |||
Changing Text to Numbers | Excel Discussion (Misc queries) |