can anyone help me please ??
i have a list of numbers in Column b which are say 1 but i want to change the number to read +001 how do i go about doing this, i have thousands tro change
Thanks
can anyone help me please ??
i have a list of numbers in Column b which are say 1 but i want to change the number to read +001 how do i go about doing this, i have thousands tro change
Thanks
I think that your Normal Style may be corrupted. So you can go to Styles in the Home Tab and right-ckick Normal. Specify modify and check the settings and make correction if necessary.
i ws looking for a way to changethe form of the numbers without changing every single one
I have found a VBA macro script that you can run to clean up the custom style list. You can try to create it in a macro, it is kind of slow, though it works:
Code:Sub TrimStyles() Dim s As Variant Dim g As Style On Error Resume Next With ActiveWorkbook For Each g In .Styles If g.BuiltIn = False Then s = g.Value .Styles(s).Delete End If Next g On Error GoTo 0 End With End Sub
Bookmarks