I have a number 099509980999. It means High 99.5% Mid 99.8% and Low 99.9% accuracy. I have been able to break it down to 0995 0998 0999 in a number format. Now I want it to look like 099.5 099.8 099.9 using a formula. I want the final product to be:

Cell A1 "High 099.5"
Cell B1 "Mid 099.8"
Cell C1 "Low 099.9"

I know I can use a & symbol to get the words in. Its the decimal I can't get in.

This is more difficult than I thought.

Can anyone help.

Thanks