From the Recorder:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 9/11/2009 by James Ravenswood
'

'
Selection.NumberFormat = "[$‚¬-2] #,##0.00"
End Sub

--
Gary''s Student - gsnu200903


"thomas donino" wrote:

Using number formatting you can set a currency symbol in a cell
like below for the euro. How is it done in vba?

‚¬ 72.80