Manipulating Excel spreadsheet with VB

[ednz]

Hi

I have set some cells in a spreadheet using

xlsapp.cells(1,2) =....

I'm setting the cells using dateserial function to give day numbers then setting the cells using those integers.

Now I want to format the cells (or the whole column) to show the date values of these cells.

Can someone advise me how to do this please.

Thanks in advance.

 

[paulbent]

xlsApp.ActiveSheet.Columns("A:A&quot.NumberFormat = "mm/dd/yy"

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[ednz]

Thanks Paul

That did what I needed.