private Sub GetWeight(RawUnits As Long, UnitMeasure As String) As String
Dim weight As Double
Dim Tmps As String
Select UnitofMeasure
Case "G" 'grams
weight = RawUnits
Tmps = NumberFormat(weight,1,0)
Case "K" 'kilo grams
weight = RawUnits /1000
Tmps = NumberFormat(weight,1,3)
Case "O" 'oz
weight = RawUnits * 0.0352739619
Tmps = NumberFormat(weight,1,3)
Case "P" 'pounds
weight = RawUnits * 0.0352739619 * 0.0625
Tmps = NumberFormat(weight,1,3)
End Select
Return Tmps
End Sub