write an Excell formula to change "17.01.2023" to "№ 17-01/23" format
user
you can use the following excel formula to change the date format from "17.01.2023" to "№ 17-01/23". assuming the date is in cell a1, enter the following formula in a new cell:

`= "№ " & text(day(a1), "00") & "-" & text(month(a1), "00") & "/" & right(year(a1), 2)`

this formula extracts the day, month, and year from the date in a1, concatenates them with the specified format, and adds the "№ " prefix.
assistant
You can use the following Excel formula to change the date format from "17.01.2023" to "№ 17-01/23". Assuming the date is in cell A1, enter the following formula in a new cell:

`= "№ " & TEXT(DAY(A1), "00") & "-" & TEXT(MONTH(A1), "00") & "/" & RIGHT(YEAR(A1), 2)`

This formula extracts the day, month, and year from the date in A1, concatenates them with the specified format, and adds the "№ " prefix.
assistant