What happens if you type: =TEXT(A1,"yy.mm.dd")
Micky


"nooris" wrote:

Hello All,

I download from SAP to excel a database. But unfortunately I can't convert
date cells to text. For Example: 2010.02.01 and if I convert to text format
i'll get 40181 data all cells.
I have tried to copy my worksheet to other worksheet with copy paste special
only values, but the result is same.

Please help!

Regards,
Nooris