Tue, 18 Dec 2007 18:03:00 -0800 from Seamless
:
I need to convert a date format to a text version of that date in order to
export to another application properly. Right now, the date format show
MM/DD/YYYY and is serialized. When I export, the text for that date comes up
with YYYYDDMM which doe not work with the application. If there is a way to
convert the date format so the text would be in order (12/18/2007) that would
be great. Please let me know. Thanks!

If the date is in A1, this formula will convert it in the way you
want:

=TEXT(A1,"MM/DD/YYYY")

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/