Hi,

Try a custom format instead.
Type in the format you require.
Otherwise we used a formula to get it into the format we needed.
Pull in the 1st 2 characters+/+middle two characters+/+last two from the cell.

i.e. =(left(a2,2)&"/"&mid("a2,4,2")&"/"&right(a2,2)
Not perfect on middle part but play around with it.

Hope this helps

"Dimmer" wrote:

Hello all,

I hope you can help with a problem we have in the office. We've got over
4,500 observations which are supposed to be in Date Format. Instead they are
in text format, e.g. "01.06.2005 08:26" or just "09.03.2005" but we need to
perform various duration calculations on them, so we need them in the Date
Format

I tried Format Cells- Category = Date, but it doesn't work. It works
however when I enter the cell and then click "Enter". very strange

Please help if you have an idea how to do it...

Thank you very much