« Blog

Convert UK date to US in Excel

If B2 is the cell with the UK number in it:

=CONCATENATE( MID(B2,4,2), "/", LEFT(B2, 2) , "/", RIGHT(B2,4))