Currency settings across a whole workbook

[NeilTewkes]

Is it possible to set a currency setting across all fields within a workbook to have the same currency setting without going into each field or block of fields?

 

[Trevor G]

Welcome to the forum,

You code use a macro to do this or group your sheets and do it in one hit.

Sub mcrChagne()
'Change number formats
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Columns("H:J").NumberFormat = "£#,##0.00"
Sheets("Sheet1").Select
Range("A1").Select
End Sub