I am not sure why but try to use paste values instead of paste.

If all the values in column A are numbers, you can try this:

Make a helper column and do =value(columnA), it should return the exact
number. Now replace copy and paste this.



navneetjn Wrote:
That did work. Amazing!!!
I just went to the worksheet "Detail" Column A and retyped the number
and voila it showed me the correct response.
Now the problem is why does it happen this way?
And since I copied the data from an Access database now I will have to
go and retype 1200 entries. Wow thats too much for a day!!! It just
defeated my original purpose of saving time.
Any way thanks a lot, if you figure out why excel 97 does that do let
me know.
;) Navneet ;)


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388108