Is there a way to change all currency formatting?

[Swillis324]

is there a way to change all currency formatting to general formatting at the same time. This is a prep-test Certiport has and I can't figure it out to saver my soul

 

[Smitty]

Welcome to the Board!

If your entire sheet is currency formatted then, CTRL+A, CTRL+1-->General will work. Or you can select multiple, non-contiguous ranges with CTRL+Left Click. CTRL+SHIFT+1 will format as number, CTRL+SHIFT+$ as Currency, CTRL+SHIFT+% as Percentage.

Or here's an add-in that takes advantage of the Special Cells dialog:
http://www.downloadfast.com/details.php?did=7648

Hope that helps,

Smitty

 

[Yogi Anand]

Hi Swillis324:

Welcome to MrExcel Board!

In addition to Smitty's contribution, you may also try the following macro ...

Sub y_1()
    For Each c In ActiveSheet.UsedRange
        If c.NumberFormat = "$#,##0.00" Then
           c.NumberFormat = "General"
        End If
    Next c
End Sub