Thread: from date format convert to text format is wrong
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nooris nooris is offline
external usenet poster
  
Posts: 1
Default from date format convert to text format is wrong
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
Reply With QuoteReply With Quote