View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Adding weight measures

Change how you enter data. Instead of:
3.13
enter:
3 13/16

Instead of:
2.11
enter:
2 11/16


--
Gary''s Student - gsnu200766


"DLM" wrote:

Can anyone help with adding weight measures? For example, how can you add
3.13 lbs and 2.11 lbs. If you sum, the answer will be 5.24 lbs versus the
correct answer of 6.8 lbs