You can use left function and get the values for each cell, assuming 1.00RREGCHO is in cell A1 then formula will be...
=left(A1,4)*1 this will convert the text to a number and then u can use SUMIF and get the sum for a particular date
=sumif(range, "Criteria", Sum Range).. assuming the dates are in column B and the values are in Column C then function will be,

=sumif(B:B,"Enter Date",C:C)