Hi,

I am trying to find a Macro for data formatting in row A to tekst formatting. It is currently displayed as a 0727838443993-like number that converts to a dd-mm-yyy hh:mm:ss form if set to date formatting. Ideally I would like the macro to change this information to tekst formatting that displays dd-mm-yyyy in column B and hh:mm:ss in column C and NOT a 0346467554873784-like number.

I know the formula solution (=TEKST(A15;"dd-mm-jjjj") but how do I incorporate that in a Macro for the entire row?

Thanks!