View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
largeone59
 
Posts: n/a
Default Turning off date formatting


Hello,

I found something on a web page that i'm trying to paste into excel.
There are some cells that have rule book references structured like
this: 2-4-3

Excel is interpreting these rule book references as dates and would
change numbers like the above example to dates like 2/4/2003

How can i stop excel from doing this when i paste?

Thanks!


--
largeone59
------------------------------------------------------------------------
largeone59's Profile: http://www.excelforum.com/member.php...o&userid=30066
View this thread: http://www.excelforum.com/showthread...hreadid=497473