Leading and Trailing Zero in Excel

DrExcel_Excel_MVP 

OfficeScript for the collection

function main(workbook: ExcelScript.Workbook) {

  const sheet = workbook
    .getActiveWorksheet()

  sheet
    .getRange("C6:C14")
    .setValues(
      sheet
        .getRange("B6:B14")
        .getValues()
        .map(x => [(x + '').replace(/^0+|0+$/g, "")])
    )
}