why wont this column format - in excel 2002

anon125

New member
Joined
Apr 22, 2020
Messages
25
Reaction score
0
Points
0
Excel Version(s)
2002
Please attached.
i have 870 of these pests!
the left column will just not reliably format!
thanks all
 

Attachments

  • wontformat.xls
    50 KB · Views: 11
Yes, you could double-click each cell to edit it then just press Enter and it should come right, but 870 is a lot to do that with!
So a one-liner macro to do it with all the currently selected cells is in the attached, just select the cells you want to process and click the button (or on the keyboard Alt+F8, choose blah and run it).
Code:
Sub blah()
Selection.Value = Selection.Value
End Sub
 

Attachments

  • ExcelGuru11058wontformat.xls
    33 KB · Views: 10
That works soooo well!
what was the problem with them?
thanks very much
 
If you widen the column those justified to the left were seen as text by Excel, those justified right were numerical (and correct), this just gets Excel to interpret the text as time.
 
And yet they could all be multiplied! my column to the right.
thanks for your great help
 
And yet they could all be multiplied! my column to the right.
Yes because Excel implicitly converts text to numbers if it can and needs to; it can also do it the other way.
 
Yes because Excel implicitly converts text to numbers if it can and needs to; it can also do it the other way.

after many times over the years of converting text to numbers ... i did not know that.
thanks for your help
 
Back
Top