frank265
New Member
- Joined
- Feb 5, 2013
- Messages
- 33
- Office Version
- 365
- Platform
- MacOS
Hi I have a spreadsheet with a file size column (column C) like this:
I would like to be able to sum all of this data, in GB, but I guess first I need to find a way to standardise all the measurements. Does anyone know of some formulas that would be able to do this?
Thanks so much...
3,2 GB |
107 KB |
290 KB |
190 KB |
167 KB |
1,9 GB |
5 KB |
122,0 MB |
I would like to be able to sum all of this data, in GB, but I guess first I need to find a way to standardise all the measurements. Does anyone know of some formulas that would be able to do this?
Thanks so much...