Excel Date to String conversion December 15, 2022 by Tarik =TEXT(A1,"DD/MM/YYYY hh:mm:ss") (24 hour time) =TEXT(A1,"DD/MM/YYYY hh:mm:ss AM/PM") (standard time)