userform textbox to always have a decimal.

[danbates]

Hi,

At the moment I have my textbox allowing 5 characters. These can only be numbers or decimal(s).

I was wondering if the following was possible?

If a user was to enter 11111. Instead of 11111 showing it would automatically put the decimal in place and it always be the third character, so it would show as 11.11

Any help would be appreciated.

Thanks

Dan

 

[danbates]

Hi Dave,

That is perfect, thank you so much for your help.

Regards

Dan

 

[dmt32]

Hi Dave,

That is perfect, thank you so much for your help.

Regards

Dan

Lucky guess but glad we could help you

Many thanks for feedback

Dave