change date format into text format.

Originally Posted by adsxvii

Hi guys..I have cell A1 containing 20051101 as a date. Need to change this into a text format and keep it looking the same. Currently when I change the format to text I get 38657(not sure why). I need to change several thousand of them. Any ideas what I must do?

Hi,

try =Text(A1,"yyyymmdd")

hth
---