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

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
 
J

JE McGimpsey

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
 
Top