Formating cells so after number is pasted it reads as MB's

  • Thread starter Thread starter crashserve
  • Start date Start date
C

crashserve

I have a spreadsheet which is being setup so that we can track th
amount of files that are being backed up on numerous computers. Th
problem is that the numbers are being cut and paste from teh backu
logs. Now when the numbers are pasted into this spreadsheet they ar
simply in bytes, is there a format that can be applied so that they ca
be expressed in MB's correctly as calculated. Would appreciate any help

Thanks, Richar
 
If you're referring to "correctly as calculated" as meaning

1KB = 1024 bytes, and
1MB = 1024 KB (1,048,576 bytes)

then no, formatting won't calculate this. Changing number format doesn't
affect the stored contents of the cell.

If you're referring to

1MB = 1,000,000 bytes

you can use

Format/Cells/Number/Custom 0,,\MB
 
Back
Top