Thanks very much for your responses. I did the 'text or date' test, and when I changed to general format it still looked like 07/13/2009 10:30 so I assume it is just text? I have now used =right(A1,5) which seems to work fine.