LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.office.developer.automation,microsoft.public.office.developer.com.add_ins
ep ep is offline
external usenet poster
 
Posts: 15
Default UDF that returns a date

Hi all,

I have a c# udf accessed as an automation add-in that needs to return dates
to Excel. I know I can't manipulate the cell's NumberFormat from within the
UDF, but is there a way to return a value that will be formatted in Excel as
a date? It seems any string value I return will default to general. Let me
know if any other info would help.

thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
date formula returns the 15th or the end of month Steve Excel Worksheet Functions 8 January 2nd 08 06:31 AM
Vlookup returns bad date slrog123 Excel Discussion (Misc queries) 3 September 21st 07 12:31 AM
Need Help. Lookup or sum technic that returns a date. sara Excel Discussion (Misc queries) 4 January 13th 07 01:40 PM
Date function returns #NUM! [email protected] Excel Worksheet Functions 5 May 10th 06 06:15 PM
Date+ returns #Num kit Excel Worksheet Functions 7 October 23rd 05 06:57 PM


All times are GMT +1. The time now is 07:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"