A Customized Add-in problem...
Posted by Vikram Peddakotla on November 06, 2000 6:51 PM
I have a function in my Add-in which takes 3 parameters (2 date parameters and a string paramater).
Function Test (Date1 as date, Date2 as date, String1 as string)
When I select a value for Date1 from the spreadsheet, the parameter gets the date value (ie. if I select a cell containing 12/12/2000, then Date1 gets the value 12/12/2000)
But when I manually enter 12/12/2000, the parameter get a value of 0.00056 (which I suspect that Excel, treats the data as numeric and does 12 div 12 div 2000, instead of treating it as a date parameter)
How do I get Excel to understand that a parameter is a date ot a text value ? I am working on Excel 97.
I would appreciate if anyone could help me out.
Thanks and Regards,