Thanks Andrew,
In a previous instance I was using it in a calculation and put the VALUE() around it but in this instance I actually need it to be text and even though I looked at it a million times, never saw the VALUE() part, just looked right past it <geez>.
Thanks for the rescue again, Pete