On Sat, 30 Dec 2006 13:59:03 -0500, "Kc-Mass"
<connearney_AT_comcast_PERIOD_net wrote:

Thanks for the thought but I tried it and I get the same result as
previously

Thx
Kevin

Clearly, given the result when type a "1" in that column, something is
formatting the column to DATE.

Why not try change the format back to NUMBER (or General) AFTER you import the
values and run your SUB on them.
--ron