Hello,

I've just spent ages researching this and not come up with what I need
to be able to do.

I have a worksheet for some simple data that has been imported, a
date, text and number column (as they display graphically to the end
user). All are a "general" format when using Format Cells.

The issue I have is that the date information is in an American date
format and I would like to change them into a UK date format. Format
Cells and selecting any option (including custom and special) makes no
changes to the imported data.

I have seen the work arounds whereby you split out the individual day,
month and year into another cell. However this does not solve the over
riding issue that I cannot make any format change to these cells.

I've also seen the Data Text to Columns and played with this to no
avail.

Why can't I change the cell formats on my imported data? How can I fix
this?

Many thanks for your help,
Jo