Download Excel Start File: [ Ссылка ]

Download workbook: [ Ссылка ]
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

свернуть