Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Lydia Hughes on Oct 10 In MS Office Category.

Len function help

Question Answered By: Terence Mitchell on Oct 10

It was definitely a string vs integer error like both of you noted. I
found the solution (with lots of help) with the following code:

CLng(Left(iGroupNum, Len(CStr(iGroupNum))) - 2)

This Question has 5 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Len function help Or get search suggestion and latest updates.

Related Topics:

Len function help
help requested for using excel's built-in function in coding
help on functions
Help with Formatting a cell holding a custom worksheet function
description/help with own VBA functions in Excel
Help with VBA function checksum
Help in writing a function
Help about RoundUp Function
Need help with "inputbox" function
Accessing help file info for non-Excel 2007 functions from VBA
Need Help for Macro to Perform Same Function Only on Certain Sheets
Wait function and Invisible function
Wait function and Invisible function
Help on a designing the help Screen
pleass i want 2 help this Question.....so plz help me.....
How can I call the function TotalPrice within another function?
HttpContext.Current function returns Nothing for spawned thread
Math function to determine if a number is an int
date Function
about JSP reset function

Tagged:len function help

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us