[Jo4321]

Thank you, as far as I can tell that seems to have done the trick!

Jo

"Peter Jamieson" wrote:


Once you've entered the date, Excel won't treat it as "text" even if you
change the cell format, until you clear and re-enter the value (or
something like that). However, you may be able to change the entire
column to text format as follows:


- select the column
- select the Data|Text to Columns... menu option
- click Next through the wizard until you reach Step 3 of 3, then
select Text as the Column Data Format.


If you are using Excel 2007, Text to Columns in the Data Tools group on
the Data tab.

The above quote comes from

http://tips.pjmsn.me.uk/t0003.htm

which probably provides more detail than you need.