copy and paste special and delimiters

Originally Posted by moneypennie21

I have tried copy and paste the columns as format 'general' to remove any text as this did occur to me as well but it still does not stop the #VALUE error. Is it something to do with the way I am copy paste special the data as 'values and number formats only' from the original spreadsheet or something to do with the original spreadsheet containing the formulas?

I am not sure, save a copy and then you can try to copy and paste it differently and see what happens. I've not given up just think to think a bit and perhaps someone else with more expertise than I can chime in. I know these things can be aggregating

Do you do any color formatting of any conditional formatting with this? The reason I ask is because I wrote a little Macro thast "fixes" any and all numbers BUT it will take away any CF you may have. I need to redo the Macro so it does not do this. Save a copy and you can try to run it

Sub changetonumber()
Dim cell As Range, s As Variant
For Each cell In Selection
  s = Trim(cell.Value)
  If IsNumeric(s) Then
     cell.Value = CInt(s)
  End If
Next
End Sub