Problem in formatting Date after paste special(value)

[parag_ca]

Dear All
On sheet 1 of my workbook I have several columns, having several formulas. I am also having a column in which date of birth of customers is written. Now my problem is that if I am copy data & using Paste Special(Value) command on sheet 2, I am not able to change format of date on the resultant data(Date of birth). Plzzz help.
Regards
Parag

 

[Domski]

Bit odd. Possibly the cell that you are entering the date into in the first place is formatted as text rather than as a date?

If you change the format of the cell you're entering the date of birth into to general does it change into a number? If not format it as a date and try again.

Dom