Hi everyone, my problem is sort of the same as above, but slightly different.
I have data that says 08/01/09 21:43:40 (as in mm/dd/yy hh:mm:ss) which is exactly what I want. Problem is, is that in the display bar, it converts the time to AM/PM so in the display bar it says 08/01/09 9:43:40 PM.
the display bar seems to be the 'computer' version, as in when I look on text to columns, delimited, it displays the data is AM/PM time with an AM PM column.
i thought if I copied and pasted the data it might retain the original displayed value (without the AM PM as I want it) but it always shows the AM PM.
HELP, I need to format it so I definately is in 24hr time.