I am having significant trouble converting a column full of numerical text into numbers. Here are all the methods I tried, which have all failed:
- Changing cell format
- Paste Special multiply
- VALUE() function
- Error Checking (they are no recognized as numbers stored as text)
- Replacing hidden characters (ALT-0160)
- TRIM/CLEAN functions
- Text to Columns command
- VBA Macro:
Sub Enter_Values()
For Each xCell In Selection
Selection.NumberFormat = "0.00"
xCell.Value = xCell.Value
Next xCell
End Sub
None of these have worked. Why is this so hard? What is the one simple thing I'm missing?
- Changing cell format
- Paste Special multiply
- VALUE() function
- Error Checking (they are no recognized as numbers stored as text)
- Replacing hidden characters (ALT-0160)
- TRIM/CLEAN functions
- Text to Columns command
- VBA Macro:
Sub Enter_Values()
For Each xCell In Selection
Selection.NumberFormat = "0.00"
xCell.Value = xCell.Value
Next xCell
End Sub
None of these have worked. Why is this so hard? What is the one simple thing I'm missing?