Hi all,

Quick question for you. Does anyone know a way (using formula's, cell
settings or by way of macro) to remove the little ' that appear before
numbers in excel after exporting from databases? I would just delete
them but I have 30,000+!! They are hindering my ability to do lookups.
I cannot export differently from the database either as I do not have
the file.

Cheers,

GW


--
giantwolf
------------------------------------------------------------------------
giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718
View this thread: http://www.excelforum.com/showthread...hreadid=465846