You're welcome. Thanks for letting me know how you solved the problem.

MyrtlePeacock wrote:
Thanks for the advice. I used the "Paste Special" method to convert the
text numbers into real numbers on my data list and then updated my PTs.
All the zeros were gone and I now have the correct data where it should
be.

Thanks again.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html