If all your data are numbers it should work with a dummy column. The
catch is you do NOT use paste values. You want to overwrite the
internal formatting.

If all your data are text, you probably did not have the problem you
have.



navneetjn Wrote:
Tried copying and pasting as values, made a dummy column and tried to
copy from that. even tried to copy from the original access databse,
tried changing the format to almost all possible configurations.
One thing did work though !!!!!
*Press "F2" then press "enter" 1200 times*

Anyways thanks for your help.
Now please help me in getting a multiple value from sheet "detail"
corresponding to a single value of A2 in sheet "header"
Navneet


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