Solved: Convert Date

[slamet Harto]

Hi there

Please help me to convert the date format to text.
Example:
10/31/2008 then convert to: 20081031.

see in the attached for your reference.
Thanks in advance.

[CCkfm2000]

try this

enter this in cell c1 and copy down =TEXT(A1,"yyyymmdd")

[slamet Harto]

It works and Thanks so much.