Output Without Formula - Is there such an animal?

[Mary25]

I want to compare storage size for file folders from week to week because I want to be able to see which folders are increasing in size.

I have a directory listing utility that lists folders by path and size. The problem is the size is in bytes and cannot be changed to output in Megabytes. So I bring all the data into Excel and do a conversion from bytes to Megabytes.

For example:
ColA
2503513B

ColB =(ColA/100000)
25.04MB

The problem is once I've converted the "Column A - Byte” data, I don't want to keep it – I only want to work with the Megabyte figures. But if I attempt to delete ColA I (of course) lose my ColB values because their values are derived from caculating with ColA.

Is there a way, once a calculation is done, to output the data just as a number without the formula?

--Mary

 

[Norie]

Mary

Copy and Paste Special>Values.

Or even better put the number you want to divide by in a cell, copy it, select the column with the bytes and Paste Special> Operation>Divide.

 

[GlennUK]

Select the output, do Edit/Copy then do Edit/Paste Special/Values.

 

[Mary25]

Thank You!

I want to thank you both for the prompt replies. I read about using the "Paste Special" command in Help but couldn't get the sequence right and kept error-ing out.

Thank you again for the help.
--Mary

 

[Atom]

Mary, when you copy and past the values, you should see a little clipboard at the bottom of the selection you just pasted, if you click on the clipboard you will be presented with a few options, select "values only". This will paste only the values from the functions in the parents cells.

 

[PA HS Teacher]

Are you willing to use a custom number format? (No calculations needed)

Book1
	A	B	C	D
1	General Format	Custom Number Format: 0.00,, "MB"
2	2503513	2.50 MB
Sheet1

Custom Number Format
0.00,, "MB"

 

[tusharm]

Dividing by 100,000 is simply wrong. It is strange no one pointed that out. Even assuming that was a typo and you meant 1,000,000 it is still wrong.

A megabyte is defined not as by decimal powers but by powers of 2, i.e., it is not 10^6 or but rather 2^20 or 1048576 bytes.

True, some marketing types use 10^6 to define a megabyte but they are the only people who do so. All you have to do is check the properties of any file or folder on any computer. Assuming the OS provides the size in bytes and megabytes (or kilobytes) you'll see the difference is a factor of 2^20 (or 2^10 in the case of kilobytes).

I want to compare storage size for file folders from week to week because I want to be able to see which folders are increasing in size.

I have a directory listing utility that lists folders by path and size. The problem is the size is in bytes and cannot be changed to output in Megabytes. So I bring all the data into Excel and do a conversion from bytes to Megabytes.

For example:
ColA
2503513B

ColB =(ColA/100000)
25.04MB

The problem is once I've converted the "Column A - Byte” data, I don't want to keep it – I only want to work with the Megabyte figures. But if I attempt to delete ColA I (of course) lose my ColB values because their values are derived from caculating with ColA.

Is there a way, once a calculation is done, to output the data just as a number without the formula?

--Mary

 

[Norie]

Dividing by 100,000 is simply wrong. It is strange no one pointed that out.

How?

 

[Yogi Anand]

Hi Norie:

because even the nominal MEGA is a million ... 1,000,000