The dread Apostrophe (1 Viewer)

[lmnop7854]

Ok, this is probably incredibly simple - how does one get rid of the dreaded apostrophe that appears in front of all my data when I expoert from Access to Excel? It is causing problems when I try to perform functions.

Lisa

 

[shades]

Probably Find/Replace - you can "Replace all" -- provided you don't have apostrophe's within cells.

Or another way to do it: in a blank cell put the number 1. Then copy that cell, select all the cells that need to be changed, Paste Special, and choose "Multiply".
________
Arizona dispensaries

 

[lmnop7854]

Dude!!! Thanks so much - that copy and Paste Special thing worked like a charm!!!

Lisa