View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NetTech NetTech is offline
external usenet poster
 
Posts: 2
Default Adding bytes, gigabytes, and megabytes in Excel

I have data in Excel that comes across as Megabytes and Gigabytes (i.e 500
MB, 3 GB, 200 BM, etc). How can I format this data so Excel recognizes these
as numbers and not text. I would like Excel to be able to add say 894 MB and
128 MB and come up with a total of 1 GB. Is this possible?

Thanks,