I have a spreadsheet with a lot of account numbers. I have autofiltered
to sum a specific account number. I copied and pasted all of the data
associated with this account number into another spreadsheet.
Everything pasted fine, but the dates changed. For example, the first
row of the original data is for 7/1/2004, but changes to 6/30/2000 in
the new spreadsheet. Does anyone know why this happens and how to fix
so that the dates are consistent between the 2 spreadsheets? Thanks!


--
deacs
------------------------------------------------------------------------
deacs's Profile: http://www.excelforum.com/member.php...fo&userid=2321
View this thread: http://www.excelforum.com/showthread...hreadid=498254