Excel add-in in C#: How to format the cell?

[Aaron Fude]

Hi,

Is it possible to write an Excel function that no only returns a
value, but also formats the cell in a certain way.

An example of such a function is "=today()" with formats the cell as a
Date.

Thanks!

Pavel

 

[Nicholas Paldino [.NET/C# MVP]]

Are you trying to do this in Excel, or are you trying to do this
accessing Excel in .NET?

 

[Aaron Fude]

Are you trying to do this in Excel, or are you trying to do this
accessing Excel in .NET?

I'm trying to do this in Excel. In other words, let's say I want to
write a UDF worksheet function "=MyToday()" which would act the same
way as "=today()".

Thanks again.

 

[Nicholas Paldino [.NET/C# MVP]]

Generally, you would want to ask this in an Excel-specific group, as you
will have a better chance at a response there.

Here is a link which should show you how to create your own custom
functions in Excel:

http://office.microsoft.com/en-us/excel/HA011117011033.aspx