Excel Magic Trick 911: Add Leading Zero and Dash, More Examples From Mr Excel & excelisfun Trick 107
Download Excel Start File: https://people.highline.edu/mgirvin/Y...
Download workbook: http://people.highline.edu/mgirvin/Ex...
SchultzesBlues and Daniel1Dion at YouTube give great examples of how to add a leading zero and dash to a number using the REPLACE function and Custom Number Formatting,
Related to this video:
Mr Excel & excelisfun Trick 107: Add Leading Zero At Front & Dash In Middle, Variable Length Numbers