Dr. Joe..thank you. works just like I want it to...now I have to figure out why. With this little diversion I am trying to program a prime factorization of a factorial as a personal challenge as I 'discovered' a way do it mentally atleast up to 60!)but I thought I'd try to program it. I did but...
I am not explaining my self well. I am trying to eliminate this character, "^", and use superscrip for the exponent.
Example: I have two arrays,
Primes()=2,3,5,7,11
Exponents()= 10,5,2,1,1
desired out is:
210, 35,52, 71, 11 1
Thanks Johnvm, That works fine for Hello world" but I still have a problem.. Here it is what I am trying to do (withOUT the "^"
I have two arrays, one of Primes() and the other of their exponents as they appear in a prime factorization of a number.
For Counter = 1 to cnt
TxtANSWER =...
tbt103...Here is what I use for both functions. (I am in the middle of changig systems and am more messed up than usual) I have never had a problem with either but also do not work with time (h:m:s)in my dates.
Public Function DateFor(JDN, JGMode)
Dim JG, M, Y
Dim DV As String
Dim D...
I am sorry. I had converted function to use in an excel sheet and had cell names where I now have MONTH DAY & YEAR Simply change these to be appropriate variable names (iMONTH, iDAY & iYEAR is ok). Depending on if you are using Julian or Gregorian dates make your flag. so it will go something...
The following code will give the Julian Day Number (the count of days since noon of 1/1/4712BC of a Julian or Gregorian date. It can easily turned into a function (Note the similarity of the THEN and ELSE portions and test in the middle.) So what you need to do is find the JDN of your your...
Thank you folks. I finally got this little experiment to work to a degree that 'satisfies' me. I have been working with the problems of MS dates for a long time now and the limits imposed by MS products of 1900 to 9999 just have not been helpful to me since my interest is in historical events...
Thanks. I need some more help. I am afraid for you that I am a rank beginner at this and at age 67 there is not much time to waste. I would be willing to share my worksheet publically or privately. It may be of some use to some out there for it works manually w/o the whistles and is accurate...
Thanks. I need some more help. I am afraid for you that I am a rank beginner at this and at age 67 there is not much time to waste. I would be willing to share my worksheet publically or privately. It may be of some use to some out there for it works manually w/o the whistles and is accurate...
I am new to Excel, but do know much more VB6 and know nothing of VBA. Could someone point me in the right direction to solve the following.
Columns B,C and D (all 3 to be hidden) are numeric (0 places) and to contain M,D,Y (Month, Day, Year) in the range of 3000 BC to the future.. Upon...
Pardon.. in above post
This
Thsee 0000--------|-----0
2 lines 0000--------|-----0 represents 10
SHOULD BE
Thsee 000--------0|-----0 Tens place
2 lines 0000--------|-----0 units place
represent 10
Perhaps I'd better make my request more clear
I want to start with several (in my example below 3)horizontal graphics in picture boxes (I think). The lines will represents
the decimal positions, ie. 1's, 10's and 100's. The line below represents the ones column. The 4 beads to the left have...
I want to make an virtual but haven't a clue! The bead(s) will be pushed/dragged by user via cursor up and dowm a vertical line. Assume 9 beads (numbered 9 to 1 rom right to left) all placed on the left side of a horizontal line. How to drag/move bead 1 or (2&1)to the extreme right and show...
re. Spelling...You're picking on me. You know I can't spell and was thinking of the person dog that looks after those animal with three consecutive double letters.. errr hmmm Shepherd.
I say "A Hair Model" and you come back with a ONE word (x) that if this person had/was x that would be the demise of that person in said occupation. In this case you might come back with "distressed" Try these:
1. Metrometer
2. Membership chairman
3. Judge
4. Sheapard
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.