Date to text format
 

I have a date in a cell in the following format 12/15/05. However I
need to make this a true text field. I can do it manually by just
going into that cell and preceding the date with a ' (single quote) so
it would be '12/15/05 but I can't copy this down to all the other
cells. Anyone know of an easy way to do this?


--
nufsed
------------------------------------------------------------------------
nufsed's Profile: http://www.excelforum.com/member.php...o&userid=19264
View this thread: http://www.excelforum.com/showthread...hreadid=374433

Format/Cells/Text, then fill down.

"nufsed" wrote in
message ...

I have a date in a cell in the following format 12/15/05. However I
need to make this a true text field. I can do it manually by just
going into that cell and preceding the date with a ' (single quote) so
it would be '12/15/05 but I can't copy this down to all the other
cells. Anyone know of an easy way to do this?


--
nufsed
------------------------------------------------------------------------
nufsed's Profile:
http://www.excelforum.com/member.php...o&userid=19264
View this thread: http://www.excelforum.com/showthread...hreadid=374433