View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Givnik Givnik is offline
external usenet poster
 
Posts: 8
Default How do I remove the ' from the begining of value in a cell

I have a column containing dates but some begin with a ' which I need to
remove programatically.... any ideas. I already have the for next loop set up
but unable to find the correct method for detecting the ' and also removing
it to leave the date entry intact.