Votes
Answers
Views
Question
1
vote
1
answer
26
views
I have a parameter containing a string value with numbers and other characters. I need to extract the numeric component. For example 12ABC2345, needs to become 123456. What is the code to accomplish this:
3
votes
2
answers
132
views
I'm trying to create a document in Excel that each time you open it, the serial number would be 1 higher. For instance the first time I open it, I'd want the number to be 00001, then 00002. But I don't want it as a list in Excel, I want it to be a new number each time I open the document. Like how y...
4
votes
1
answer
137
views
asked 13 years ago by viperboy1012
updated 12 years ago by garystew
While not normally needed, how does one go about utilizing math functions with very large numbers, without getting an "overflow" error? Numbers treated as integers go from -2,147,483,648 to 2,147,483,647; yet, how could one utilize, say, 1e+15 or 3e+50? I've tried using CDbl and CLng, neithe...