Sub nopreapostophe()
For Each c In Selection
If c.PrefixCharacter = "'" Then c.Value = c.Value
Next
End Sub

works best
HTH

"giantwolf" wrote
in message ...

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