using len function

[vbaNewby]

Hi all,

I have a variable called myNum.

myNum contains numbers like 12345.67

What I want to do is use len function.

someOtherVar = len(myNum)

But this gives me 8, I want it to not include the decimal or the number that trails the decimal.

Desired result = 5

Thanks in advance.

 

[Canapone]

Hi,

I don't use Vba (just an attempt), the formula could be

=Len(round(myNum,0))

Hope it helps

Regards

 

[Rasm]

try the Fix command (it truncates-so make sure u r ok with that) instead of len - len is length of a string

 

[vbaNewby]

Hi,

I don't use Vba (just an attempt), the formula could be

=Len(round(myNum,0))

Hope it helps

Regards

numDigits = Application.Len(Round(largestNum, 0))

Error. I don't think application.len exists....?

 

[Rasm]

try this - I read ur question wrong


someOtherVar = len(fix(myNum))

 

[vbaNewby]

try this - I read ur question wrong


someOtherVar = len(fix(myNum))

Works like a charm! Thank you!