I'm trying to progmatically set the number format for a range of cells to be the same as the standard UK currency format. I;ve set the NumberFormat to "\£#,#00.00;-\£#,#00.00", but it fails to add the £ sign and when I look at the spreadsheet it shows the format as Custom. Anyone out there know what format I should use.