flummi,

thanks for the input.

I don't want to format the receiving cell as date because the source
cell is formatted as date and that is the problem that I am trying to
solve. I need to achieve the following YYYYMMDD as a text field for
input into a system that does not accept date formats.

Your suggested formula generates an error.

Regards
Tony


flummi Wrote:
Either format the receiving cell as date or use this formula to move
the date across: =TEXT(A1;"MM/DD/YYYY")


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