Quote Originally Posted by Mxjerrett
Well here is a rough version

Code:
Text2 = Format(Text1, ".#############")
That's exactly what he doesn't want to have happen.

Try

Text2 = Format(Text1, "0.0")