View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dee Sperling[_2_] Dee Sperling[_2_] is offline
external usenet poster
 
Posts: 29
Default Importing number with dash changes to date

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