Anne,

I assume that A1 refers to the Cell holding the date.
When I enter the suggested formula I get a result of 1.


Anne Troy Wrote:
=TEXT(A1,1)

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"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



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