programatically formating a cell/cellrange
Posted on 2006-07-15
How do I programatically format a cell/cellrange to General Date or Time Value from VB.NET.
The problem I'm having is I've got a formula that is returning a serial Value instead of Hour:Minutes:Sec in my excel sheet. I tought about using the Hour,Minute and second Function of Excel (and its working BUT its not formating the values properly for me.
Alternatively if I can find the Excel equivalent of VB.NET's funtion Format(String,"00"), I'll be good.