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
|