ExcelBanter - cell formatting

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - cell formatting (https://www.excelbanter.com/new-users-excel/143257-cell-formatting.html)

change 04/02/07 to 040207[_2_]

cell formatting

I need to have 04/03/07 displayed in the cell as 040307 no dashes

Gordon

cell formatting

"change 04/02/07 to 040207"
wrote in message ...
I need to have 04/03/07 displayed in the cell as 040307 no dashes

create a custom format - ddmmyyyy

All times are GMT +1. The time now is 07:09 PM.