hi
im using this formula to convert dates like this 08/26/2011 to 26/08/2011
the formula work for that type of date here is the formula
=RIGHT(LEFT(B3,6),3) & LEFT(B3,2) & RIGHT(B3,5)
but when i get a date like this
8/26/2011 that formula does not work any when i play around with it cant get it.
anyone have any ideas
Bookmarks