[RESOLVED] Date cell format

[cssriraman]

Could you please explain more clearly?

anyway,

If you work in Excel,

If you add the cell value to list1 list box, use the format function:

list1.additem format(Range("A1").value, "DD/mm/yyyy")