Thread: How to remove the ' charachter
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How to remove the ' charachter
In the worksheet (not VBA) use the =DATEVALUE() function. It does a good job
of converting text into a real date (and doesn't care about leading
apostrophes)
--
Gary''s Student


"Darin Kramer" wrote:


Howdie,

I have the date that has been imported, and it is displayed as '20
January 2006

Now I know that the ' defines it as text

Question is how to a make it a number(ie a date format) ...? Find and
Replace ' doesnt work, nor does formatting cells....???

Thanks

D

Thanks


*** Sent via Developersdex http://www.developersdex.com ***

Reply With QuoteReply With Quote