how to remove % using VBA in excel

[jj0911]

Hello,
i have an excel file with a lot of columns in different tabs that have % signs. i want to write a VBA macro to remove all % sign. for example 98.23% change to 0.98 and 67.9% change to 0.68 etc. there are a lot of these percentages in different columns and different tabs in the excel file. so i am thinking to write a VBA function or a macro code to change those percentages but don't know how to write the code. would be appreciate if somebody can help me on this.

 

[bebo021999]

Try with multiple sheets, in each sheet, it search for cells with %

Option Explicit
Sub changeFormat()
Dim ws As Worksheet, f
For Each ws In Sheets
    Set f = ws.UsedRange.Find("*%", , xlValues)
    If Not f Is Nothing Then
        f.NumberFormat = "general"
        Do
            Set f = ws.UsedRange.FindNext(f)
            If Not f Is Nothing Then
                f.NumberFormat = "general"
            Else
                Exit Do
            End If
        Loop
    End If
Next
End Sub