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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cut & Paste in Excel without erasing cell borders? 1
problem with pasting & #value 5
Format Questions 4
Formatting cells for phone numbers 1
Formatting long decimal numbers as TEXT cell, not refreshing? 2
Pasting Hard Coded Number Only from within a range. 2
Cut and paste from web pages, emails, is breaking up text into multipleExcel cells 3
Imported Numbers not recognized as numbers 4

Back
Top