TRIM() function removing date format in Excel

[csmathers2]

How do I retain a date format when using the TRIM() function in Excel? 

[#2 · Accepted solution]

try this
=--TRIM(cell)

Regards D

[#3]

Thanks, Dean - that did the trick!