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
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