Thread: How do I remove the ' from the begining of value in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default How do I remove the ' from the begining of value in a cell
Hi

Range("A1") = Range("A1")*1

--
Regards

Roger Govier


"Givnik" wrote in message
...
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.


Reply With QuoteReply With Quote