View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default Convert Date to STring

On Wed, 15 Feb 2006 00:40:36 -0600, tonymaguire
wrote:


How do I convert a date (25/11/2005) in a date field to the same string
in a General or Text field? Whenever I try Excel converts to the
serial value of the date.


You use the TEXT worksheet function.

eg: =TEXT(A1,"YYYYMMDD")


--ron