At a guess - Excel is treating the entry as text, not a date. Therefore,
changing the cell's format will have no affect on the display.

You can determine how Excel is treating the entry by selecting an empty cell
formatted as General and entering a reference to the cell with the entry. If
it comes back as the same string, then Excel thinks it's text. If a number,
then Excel thinks it's a date


"Jon" wrote:

The original date structure has been imported from MSP and appears in the
following format - Fri 19/05/06 08:00

"Jon" wrote:

I have tried doing this with the file saved as an excel workbook however the
field still doesnt change the format to dd/mm/yyyy?

"Jon" wrote:

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!