Cant convert to True numbers

[thedeadzeds]

Hi Guys,

I have a list of numbers in columns A to D but they dont seem to be actually numbers. I've tried using =Value and =Int but I get an error. I've also tried using the below code but they still wont covert to true numbers. Any ideas?

'Convert Number stored as text to Number
Sub VBAF1_Convert_Number_Stored_as_Text_to_Number()
   
    'Variable declaration
    Dim rngRange As Range
    Dim Lastrow As Long
    Lastrow = Sheets("ScoreCard").Cells(Rows.Count, "A").End(xlUp).Row
   
   'Define Range which you want to convert to range
    Sheets("ScoreCard").Select
    Set rngRange = ActiveSheet.Range("A2:D" & Lastrow)
  
   
    'Convert Number
    rngRange.Value = rngRange.Value
  
End Sub

Also, there are no space etc in the cells example below

67.00

100

18

113

 

[Alex Blakenburg]

Using any of the cells as an example what value do the formulas below return:

=UNICODE(LEFT(A1,1))

=UNICODE(RIGHT(A1,1))