"M Thompson" wrote:
Max...this worked fantastic! Thanks much.
No prob. Glad that did it for you

Can you give me some idea how this forces it to a number?
Not exactly sure how, but that's one of the techniques to force text nums to
real nums. It "triggers" Excel to do it. You could also do a "multiply by 1"
operation instead of an "add zero" calc to achieve the same effect.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---