Votes
Answers
Views
Question
1
vote
1
answer
15
views
asked 6 years ago by
updated 6 years ago by
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
113
views
asked 12 years ago by
updated 12 years ago by
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
113
views
asked 13 years ago by
updated 12 years ago by
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...
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top