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?

Format/Cells/Text, then fill down.

"nufsed" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>