Excel Date Auto convert
Posted on 2014-03-04
I have cells that requires date input either by typing data in the cell or pasting from another cell. the inputs have to be only dates in MM/DD/YYYY format. however some users by mistake might enter DD/MM/YYYY and therefore i want something like a auto correct or validation that if a user enters data in DD/MM/YYYY then in the cell in converts it and shows it as MM/DD/YYYY.
i tried data validation with text function, somehow i cannot get it right.
appreciate any help on this.