Excel 2010 changing number formats

[austinsandford]

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

[EINSTEIN_007]

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.

[austinsandford]

i ws looking for a way to changethe form of the numbers without changing every single one

[JAMES_911]

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:

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