Is there a way of using data formats i.e. GB MB kb in numbers?
I'm trying to add the size of library files together to estimate HD requirements. If I had the files on my system I could just put them in a folder and the OS would calculate them for me, but I don't have them yet. I have a list of files and their sizes in GB.
Has anybody worked this out?
I suggest the following:
Create a second table called "Convert"
In that table enter the first column as show (pasted here so you can copy)
Value | Divide by | suffix |
0 | 1 | b |
400 | 1024 | kb |
1000000 | 1048576 | Mb |
1000000000 | 1073741824 | Gb |
1000000000000 | 1099511627776 | Tb |
Now in Table 1 use the Convert table to modify the files sizes in to the appropriate format:
C2=ROUND(B2÷VLOOKUP(B2,Convert::A:C, 2, 1), 2)&" "&VLOOKUP(B2,Convert::A:C,3,1)
this is shorthand for... select cell C2, then type (or copy and paste from here) the formula:
=ROUND(B2÷VLOOKUP(B2,Convert::A:C, 2, 1), 2)&" "&VLOOKUP(B2,Convert::A:C,3,1)
select cell C2, copy
select cells C2 thru the end of column C, paste
Is there a way of using data formats i.e. GB MB kb in numbers?
