need military time 1

[renartbrazil]

Is there an easy fix to format this for miltary time?
This is what it looks like now.
3/14/2005 1:55:24 PM
I am trying to get this format though.
3/14/2005 13:55


<code>Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Target(1, 3) = Date
Target(1, 4) = Time
End If
If Target.Column = 5 Then
Target(1, 3) = Date
Target(1, 4) = Time
End If
End Sub</code>

 

[PHV]

Have you tried the macro recorder when you change the cell's format ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244