setting format cell accounting using vba

**spexcel** · 03-26-2009, 12:18 AM

Hi,
i am doing some calculations using vba in excel, i need to know how to set the cell format to 'accounting' in vba ?

thanks for the help
sam

**royUK** · 03-26-2009, 03:01 AM

The easiest way to check for code like this is to use the macro recorder

ActiveCell.NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)"
End Sub

**spexcel** · 03-26-2009, 02:25 PM

Perfect !!, works like a charm, thanks Roy for your help !

Re: setting format cell accounting using vba