text as numbers

Hi all, I want to get a formula. Please help. Thanks!!! If column A is "test a", SUMPRODUCT (column B,column C), but calculate "DF" in column C as "1" . I can only get =SUMPRODUCT(B:B, C:C,--(A:A="test a")) , I don't know how to calculate "DF" in column C as "1" . <tbody> test a 2...

Excel 2007 <tbody> Row\Col A B C D E F 1 712345678 2 712345678 3 123745678 4 8234756 5 6 8234756 7 712345 8 LK 9 7123 10 Y712345 11 12 13 Answer: 14 No. of items (that are...

Hi, I have a report that has a Total Sales field that comes into Excel as $140. I believe Excel thinks it is text because of the $ I need the VB code to loop thru each row & convert it to a number I'm using Excel 2007. I've been trying this myself but haven't figured it out. Thanks in advance...

Hi, (using Excel 2013, 32bit on a German system) I'm having a slightly complex PowerQuery that is loaded to the DataModel/PowerPivot. The query does the following: 1. Load data from a MySQL DB, calculate some additional columns with Table.AddColumn 2. Load multiple other tables from MySQL, CSV...

I am querying data from a third party database via MSQuery and need to evaluate a text field as a numeric field in order to set a range criteria. The text field has either null values or numbers. Is there a way to switch the field from text to numeric in the query? Thanks in advance for any...

How do I have VBA understand that my content is text, not numbers? I keep getting an error when I try to run my code because my words have dashes in them. Here is the part of my code that is giving me issues: Word = "I-BUTANE"

I have data in excel with the following time format (07:03:56.903); however, some of the times are in text format (0710251) and only to seven digits. I am trying to convert the text to the same format as the above time "hh:mm:ss.000" thanks in advance for any suggestions <tbody> </tbody>

In Cell A1 I have the text: As of March 1, 2014 In cell A2 I need a formula that obtains the result: 3/1/2014 Looking for a simple formula. Thanks

Hi All, I am trying to create a dynamic chart that updates based on user-inputs for the x-axis and y-axis. I have a working lookup table based on the user inputs (i.e., user has a dropdown menu to select x-axis or y-axis variables, and then an off-tab lookup table updates based on those...

I have a field in my table called [Capture ID]. This field is formatted as text when the table is imported from another system, but is always contains a nine-digit Integer, and I want to change the data type. I was attempting to do it in a make-table query, like this: Format([Capture...

This drives me crazy. It's so simple but it never seems to work right anymore. Cell A1 always has either a Y or a N in it I want Cell A2 to give me either a 1 for "Y" or 0 for "N" based on cell A1 So the simple formula should be: IF(A1="Y",1,0) Right? Sometimes it will do this (place...