sorry..
here's the data
Sub test()
Dim sDate As String, sName As String, sCurrency As String
sDate = InputBox("Enter date", "Date Input", Format(Date, "mm/dd/yyyy"))
sName = InputBox("Enter name")
sCurrency = InputBox("Enter value (number only)")
Range("B1").Value = DateValue(sDate)
Range("A1").Value = sName
With Range("C1")
.NumberFormat = "$.00"
.Value = Val(sCurrency)
End With
End Sub