View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vic Vic is offline
external usenet poster
 
Posts: 117
Default 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?