Excel Magic Trick 1058: Convert YYYYMMDD to Serial Number Date with =TEXT(A1,"0000-00-00")

12M views

excelisfun

5 months ago

Excel Magic Trick 1058: Convert YYYYMMDD to Serial Number Date with =TEXT(A1,"0000-00-00")

Excel Magic Trick 1058: Convert YYYYMMDD to Serial Number Date with =TEXT(A1,"0000-00-00")