thanks for the help guys. i have a couple more questions im hoping you
can help me out with. is there a way to make excel treat everything as
a text before loading a file? right now i have to fix every single cell
with the error after opening the file.

i also tried selecting the whole column with the errors and choosing
format cells -- text hoping that it would change the #NAME? to the
correct text but this didnt work. am i doing something wrong or is
this not possible?


--
spr1nt
------------------------------------------------------------------------
spr1nt's Profile: http://www.excelforum.com/member.php...o&userid=33528
View this thread: http://www.excelforum.com/showthread...hreadid=533212