the cell content = Fri 18/08/06 17:00
I want to display in date time format just the date

so i select

Select Format cell to dd/mm/yyyy

however this doesnot alter the field value to display in that format. I am
working with a csv file would this effect this??

I basically want to use that date formatted field and adjust another cell
representing that field by 7 days, however i get the #Value error duie to the
previous cell format not working!

Any help would be greatly appreciated!