Thread: Add apostrophe
View Single Post
  #1   Report Post  
Tony Wainwright
 
Posts: n/a
Default Add apostrophe

Hi guys

I am writing an Access d/b that uses an Excel spreadsheet as it's data
source. The spreadsheet contains about 24,000 rows. I have noticed that in
some of the columns numbers are formatted with an apostrophe. I would like
to create a routine that searches through specified columns and adds an
apostrophe to the start of each entry, but I am not that familiar with
Excel. Does anyone know where I might find such a routine