இவற்றிற்கான களஞ்சியம் 'Excel' வகை

Sep 10 2006


Excel date format fix

Filed under Excel,Programming,Scripts

formula to reformat date from

Either set regional and language options to match the format

OR

DD/MM/YYYY to MM/DD/YYYY

OR
MM/DD/YYYY to DD/MM/YYYY

=(SUBSTITUTE(MID(C3,FIND(“/”,C3)+1,2),”/”,)&”/”&SUBSTITUTE(LEFT(C3,2),”/”,)&”/”&RIGHT(C3,4))

No responses yet

அடடா » தவறு

Sorry, you are not allowed to access this page.