A simpler method would be to enter a 1 into an empty cell. Copy that cell.
Then select your range of data to "fix". Select "Paste Special", and check
the box for "Multiply". This will remove all leading apostrophes. You can
then delete the 1 that you origianlly entered.

HTH,
Elkar


"Dave O" wrote:

This is a common problem- look at this post from Dave Peterson for a
solution:
http://groups.google.com/group/micro...15 da40bf621b