Remove time from data and time picker

[Wayprof]

Hi Guys - I've managed to add the data and time picker to chosen cells in my spreadsheet.

How can i choose the date only without the time also populating the same cell ??

I dont need the time displayed - just the date in the cell.


I look forward to your reply...


Wayprof

[TMS]

Use a Custom Format, or possibly just the standard Short Date Format.

[Wayprof]

Still doesn’t work - any more ideas ???

[Wayprof]

I have this script to put the date and time in cell F5

------------------------------------------------

Private Sub Worksheet_SelectionChange(ByVal Target As Range)


With Sheet1.DTPicker1
.Height = 20
.Width = 20
If Not Intersect(Target, Range("F5")) Is Nothing Then
.Visible = True
.Top = Target.Top
.Left = Target.Offset(0, 1).Left
.LinkedCell = Target.Address
Else
.Visible = False
End If
End With

End Sub

------------------------------------------------------------


Is there an amendment I can make to remove the "time" element ?

[TMS]

Well, the Date part of a Date and Time value will be the Integer part. However, I no longer have Excel 2003 so I cannot rest any solution.