I would like to parse a string into Currency. For example when the user enters 24885 instead of 248.85 the function returns 248.85. So far I've gotten this but I can't figure out how to read the string leaving out the last two digits (it could vary in length).
The x in dollars is just a place holder b/c I have no idea what to put there or if the line should be different.
Please Login or Register to view this content.
Last edited by lloydgodin; 12-05-2012 at 05:17 PM. Reason: Clarification
Maybe dollars = CCur(left(iCur,X))
but what is X?
Try this
dollars = CCUR(left(iCur,len(icur)-3))
I edited the post to clarify that it's a place holder because I have no idea what to put there. Or if something should even go there...
oh wait!!!
x could be the length of the string - 2?!
Got it. Thanks!!Please Login or Register to view this content.
FINALIZED CODE:
USES LINE BELOW TO USE THE FUNCTION:Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks