I have been asked to give a total of all the Liters since 2006. In the excel
column there is a quantity using numbers but after the number is (L) for
liters. I wanted the total sum of about 2000 rows and cannot get it unless I
manually delete all the (L)'s from each cell individually. Is there a way
to take out all the (L)'s at the same time or am i going to have to do all
the 2000 entries separately.