Good morning Gurus,
I have a column of dates (mm/dd/yyyy and mm/dd/yy).
How it came to me has some spaces on both ends--blank lines and such.
I wanted to use trim and clean to ensure just the date is left in the cell.
When I run it, some cells work perfectly and some dates gets converted back to an integer value even though the cell where the formula is has been formatted to a date.
Is there some prep work on the original column I should be doing? Some dates are fine which removes the concern about the "/" getting cleared.
thanks as always.
Bookmarks