inches

I need to write a UDF to convert a general string expression for feet and inches into two real numbers (feet and inches). The possible string inputs can be: 3' 4.5" 3 ft 4.5 in 3ft 4.5in 42.1" 42.1 in 42.1in 3.5' 3.5 ft 3.5ft Is there a better way than a bunch of nested IF statements where I...

I am trying to size my rows and columns by inches, instead of pixels and cannot get it to work. I went to Options>Advanced>Display and changed the default to inches. When I type in these options I get an error message....1/4, 1/4 in, .25 in. Error message - Your entry cannot be used. Am...

I have a table with date in column A and amount of rainfall in column B. In column C I need to count if there is an occurrence of rainfall over 2 inches in a consecutive two day period. If the rainfall does exceed 2 inches it is counted and the calculation starts over for the subsequent days...

I have a table with date in column A and amount of rainfall in column B. In column C I need to count if there is an occurrence of rainfall over 2 inches in a consecutive two day period. If the rainfall does exceed 2 inches it is counted and the calculation starts over for the subsequent days...

I am new and have never worked with macros. I have 30 different workbooks with cells that have their values in MM and I want to convert all of them to Inches. I will eventually have to do this with a few hundred workbooks. All the workbooks have the cells that need to be converted in the same...

I am trying to take 2 feet in cell A1 and in A2 show inches (millimeters) that it is 24 (609.6). I know how to do it in separate cells but trying to combine it in one cell. This is for approximately two hundred rows so I wanted to automate the formula.

I would like to enter 12 5 in a cell and have them return 12'5" as a result. I don't know how to enter the formula in the format cells dialog box. Any help would be appreciated.

Hi, I have this program that reads a number of cells which have some measurements in inches with the following cell format # ??/?? so i get te following results (all numbers rounded to 1/16): 58 58 1/4 3 1/16 etc 13 3/8 when the macro reads the cell it reads it as decimal. 58 58.25 3.0625...