inches

  1. H

    Adjust Row Height & Column Width in Inches

    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...
  2. T

    Count the occurrences of rainfall over 2 inches within a two day period.

    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...
  3. T

    Count the occurrences of rainfall over 2 inches within a two day period.

    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...
  4. K

    Converting values from MM to Inches in multiple cells and multiple workbooks

    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...
  5. S

    inches millimeters in the same cell

    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.
  6. F

    How to format cells to show ' and " for feet and inches

    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.
  7. B

    Working with Inches/fractions

    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...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top