Thread: [SOLVED] convert a text date into a proper date
View Single Post
  #4  
Old 01-09-2009, 06:28 PM
martindwilson's Avatar
martindwilson martindwilson is offline
Forum Guru
  
Join Date: 23 Jun 2007
Location: London,England
MS Office Version:office 97 ,2003 ,2007
Posts: 6,075
martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding
try
=VALUE(A1)
edit oops to quick sorry
that returns 1 jan 05
Reply With Quote