-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
numerical value
-
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...- scanavan10
- Thread
- numerical value pivot sql text
- Replies: 2
- Forum: Excel Questions
-
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- cata2200
- Thread
- cata2200 color colour numerical value
- Replies: 4
- Forum: Excel Questions
-
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 _...- dig475
- Thread
- macro numerical value
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Payment term and Cash flow (formula linked with costs)
- Started by Adfinance
- Replies: 43
Hi everyone, I need to calculate automatically the cash position (cashout) based on payment terms and costs. The payment terms may change, so I... -
Match to a list with wildcards
- Started by The Gent
- Replies: 29
Good day all, I am trying to do something which it my head feels quite simple but I can't get a result. I have four dimensions in a spreadsheet... -
Inserting text above first blank row then above third blank row etc.
- Started by Livin404
- Replies: 24
Greetings, I have a VBA where I'm trying to insert text into blank cells. On worksheet "Deficiencies" I have seven groups of ranges that I... -
code to get students marks from source sheet to destination sheet.
- Started by rzml
- Replies: 22
hi, I am looking for a VBA code that can get student marks using his ID and evaluation type (as headers) from source sheet to destination sheet. I... -
Run VBA on all open tabs
- Started by Dannottheman
- Replies: 22
Hi, I searched but could not find an answer to this. How can I make the 3 VBAs below run on all the open sheets/tabs in my Excel? Right now I... -
Functions to separate a string separated by commas
- Started by jeffdolton
- Replies: 22
Hi, I’ve opened up another thread as my request this time is a little different. With help from experts on this forum, and using some basic excel...