text as numbers

  1. Y

    The problem is about formula SUMPRODUCT, please help, thanks.

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

    Count items that begin with digit 7 (items could be number or text)

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

    Convert Text Field to Numeric

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

    PowerQuery number columns becomes text in PowerPivot - how to avoid?

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

    Evaluate text field as numeric through MSQuery

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

    VBA Syntax: Writing as Text, not Number

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

    Converting Text to Time Format

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

    converting a text date to actual date

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

    Dynamic or conditional formatting

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

    recast format without renaming field

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

    Convert text to number (weird problem)

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top