"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