Hi I'm using com objects to format cells in an excel sheet from VB.NET code.
I've got code for simple formatting like so:
EX.Document.worksheets(1).Range("A1:A1000").Font.Bold = True
I need to be able to specify that cells in a certain range should be left padded with zeros where they are less than 4 characters long.
Does such functionality exist to do this??