Apostrophe Issue

[Onestopfanshop]

An apostrophe has appeared at the beginning of the words and/or numbers in the cells. I have tried using the "Replace" feature to remove these apostrophes and it won't work. I need to remove the apostrophes so I can upload our inventory, as the SKU must be pulled exactly. Any ideas?

[VBA Noob]

See link

http://support.microsoft.com/kb/214285

or use a formula in the next col like below and paste special values then you can delete the first column

=MID(A1,2,9^9)

VBA Noob

[Ron Coderre]

See if Excel is trying to emulate Lotus 1-2-3...

From the Excel Main Menu:
<tools><options><transition tab>
All checkboxes should be UNchecked

Does that help?

[Onestopfanshop]

Thank you everybody! Worked perfectly!