numerical value

  1. S

    Pivot tables using an external CSV file is pulling numerical data through as text

    Good afternoon, I have to run large reports from a system so I generate the output in csv format. In the past I would run a pivot in excel using SQL to pull in the data from the CSV. Recently the source system has been upgraded. Since then, if I open the pivot I can see numerical data as...
  2. cata2200

    Numerical value of a colour

    Hello all I'm looking for a function/formula to get the numerical value of the background colour of a cell.:confused: Thanks Catalin
  3. D

    How do I make my Macro stop copying the title row too??

    Hi, In my macro, I am copying and pasting a value, this is the code: If Cells(i, 7).value > 0 Then With Cells(i, 7).Select Selection.Copy Cells(i, 9).Select Selection.pastespecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _...

Some videos you may like

This Week's Hot Topics