change DD/MM/YY to MM/DD/YY
I need to change DD/MM/YY to MM/DD/YY in a description field but not in all
cells. The date is in the middle of description. All American description
fields have dates in MM/DD/YY and all European description fields have
DD/MM/YY. Please keep in mind that this is NOT a date field and the field
contains other words besides the date. The date is in the middle of the
description.
How do I do that?
|