In VBA, add a decimal after the 5th digit of a number.
I have a number, like this, "394154616203704" and I need to place a decimal after the 5th digit, like this: 39415.4616203704
There can be a varying amount of digits after the decimal. I need to do this in VBA to a number that is in a text box.
I have been playing with the Format function but can't seem to get it right. I greatly appreciate your help.
left("394154616203704",5)&
or
left(me.textname,5)&"."&mi