Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calendar Control Date/Number format

Status
Not open for further replies.

bluebilly

Technical User
Nov 11, 2002
48
AU
I've linked the calendar control to a cell in my worksheet (k25), but how do I permanently set k25 to a number format as opposed to a date format ?
Despite formatting k25 to Number format, everytime I select a new date using the calendar control, it returns say, 20/02/2003 instead of 3762 in cell k25, the latter format I require for sorting.

Any ideas ?

Thanks
Bill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top