Thread: Add apostrophe
View Single Post
  #1   Report Post  
Posted to microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Tony Wainwright[_2_] Tony Wainwright[_2_] is offline
external usenet poster
 
Posts: 1
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