Format Cells Date (or any change) not working on imported data
 

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

Format Cells Date (or any change) not working on imported data
 

Please don't multi-post
You have an answer in your other thread.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ...
| 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
|