When you import the data (either programmatically or manually), tell Excel
that the field is Text. That way, no conversion will take place.
--
Gary''s Student - gsnu201001


"Dee Sperling" wrote:

I'm imporint data (which I have no control over) into Excel. Some of the
number contain 2 digits, a dash, then 6 more digits, for ex 02-9098 Excel
interprets that number as Feb 1, 9098. Changing the cell format to number or
text does not get the original value back, instead, I get 2629049 which is
obviously not correct.

Is there a way to undo the date and get the original number back?

Thanks,
Dee Sperling