Hi!

Not sure what you want to do this for, but.........

When you enter a date in a cell and Excel recognizes it as a date, it
automatically sets that cell format to DATE. The true underlying value of
that cell is the date serial number. So, changing the format to either
GENERAL or TEXT, you end up with the date serial number. (when formatted as
TEXT, then it's a TEXT number)

You could enter the string preceded with an apostrophe: '25/11/2005, but
it's strictly a TEXT entry and can't be used in calculations (easily).

Biff

"tonymaguire"
wrote in message
...

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.


--
tonymaguire
------------------------------------------------------------------------
tonymaguire's Profile:
http://www.excelforum.com/member.php...o&userid=27819
View this thread: http://www.excelforum.com/showthread...hreadid=512562