How can a format a cell in Excel to currency from VB?
I think I have the first bit but I can not figure it out

Also how do I format column B so that everything in it is centred?

x1sheet.Cells(10, 2).


Thanks