unit conversion

This is probably a dumb question but I have a large set of numbers in an excel spreadsheet that are in the wrong format for what I need (ng/ml instead of uM/L). Is there a simple way to convert all the numbers in the spreadsheet? I know what formula to use, just no how to easily apply it to...

Hello Everyone, Could you please help me find another solution with the following: I have sums of Bytes that exceeds many gigabytes in a Pivot Table. I would like to "format" these long numbers in terabytes or, at least, in gigabytes So far, the only way I've found is by adding a calculated...

I've made a custom unit conversion function to include units not included with the CONVERT function in excel. The gist of the code is below Option Explicit Function Conv(Amount As Double, Class As String) As Variant Dim factor As Double, A(57,1) As Variant, B(13,1) As Variant, UnitType As...

Hi, I'm making a unit conversion table in Excel.. figured out the CONVERT fomula; however, i'd like to have a formula that works 2 ways. For example: http://www.wbuf.noaa.gov/tempfc.htm This will reduce the cells needed for this operation from 4 to 2-3. Please let me know! Thanks ;)