Date Value Returns a Number in Cell

Good Afternoon,

I have a small problem where I 'm using an input box to enter a name of the sheet & the date in a cell, However when it asks the user to enter a date it only shows a number as the date?

For example I enter 12/31/2009 it places 40178 in the cell?

Any Idea's what I'm doing wrong?

Thank You, Mike

Please Login or Register  to view this content.

Maybe

Please Login or Register  to view this content.

VBA Noob