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.