i have column "C" formated as a date format ("dd-mmm-yy").
I did this by selecting column c and then clicking formatcellsdate..and
selecting "14-Mar-98" in right hand section.

So when i enter 40018 into cell "C1" then cell reads "24-Jul-09"

i need to put some statement into the adjacent cell ("D1") which if
formatted as "text", so it reads the cell content not the value.

i.e range("C1").value="400018", I need to have "D1" read "24-Jul-09". I
tried to copy and paste special but there is no "Text" option.

My problem is that there are around a 20,000 rows popolated. How can
iachieve this please?

Sunil