In cell A2, I use the trim function to trim cell A1 containing a date eg
1202/09, the result in A2 is 39856. However, this 39856 is text and not date
value. I therefore cannot convert it back to date after the trimming. Can
someone please help? Many thanks...
--
exalan