I can't see how it would be a formatting issue. In sheet 1, is
02/15/2002 the result of a formula? If so, then if you paste the
formula into a different cell location in sheet 2, then the automatic
change of cell references may be causing the formula to pick up
different inputs, thereby deriving a different result.