I created a custom list importing from spreadsheet a list of names and
hyperlinks. for ex text = xyz pqr hyperlink http://xyzpqr.aspx
on the spreadsheet you see the text xyz pqr.. but after import the
list shows the http address and not the xyz pqr.. Originally i did
this it worked fine, but when the hyperlink addresses were changed i
deleted the list. reworked the spreadsheet with the new hyperlinks and
created a new list.. that's when the list started showing the links
and not the text.

anyone know what happened or more importantly how to fix it?