numbers stored as text

  1. M

    Advanced Filter

    How would you set up advanced filter if you want to collect records of a dataset that contain numbers stored as text, and you want them starting with the partial text 646&"*" or 647&"*". I have a dataset where a column contains account code in text format such 6****** and I want all of those...
  2. T

    Convert All Numbers Stored as Text

    Hello World, I have a table of data that looks similar to this: <tbody> A B 1 Item1 Apple 2 Item1Weight 50 3 Item1Height 25 4 Item2Length 10 </tbody> This structure repeats about 500x. I am importing data currently and the green arrows apprear in the corners and say numbers stored...
  3. A

    Numbers as Text Causing Problems

    Hi All, I'm sure this is a common theme on this board, but numbers appearing as text is causing me a helluva problem. I'm running an awkwardly complicated series of if statements with vlookups matching property codes in the first column and returning data from second column (see sample data...
  4. M

    Converting numbers stored as text to numbers

    Hi - looking for help here. I have tried to use the small green triangle to "convert to number" but this returns a scientific value stored as "general" format (from 350298922105792620 to 3.50299E+17). I have also tried multiplying by 1 but this seems to be rounding the value...
  5. X

    Convert numbers in to text

    Hi all, Please help me with the following dilemma. I am using excel to create invoices via MS Word. But word cannot handle numbers correctly, format issue, so I am converting numbers in Excel to text. The problem I have know is that converting numbers in excel tot text Excel only shows the...
  6. B

    vba code for formating cell values to numbers

    I have a huge dataset in columns b of mulitple worksheets that are six digit values. When I try to manipulate them (add together, multiply etc) I get "#VALUE" or "#N/A". If I retype a value over a cell, the manipulations work so it leads me to believe they aren't formatted as values. I have...
  7. C

    Numbers Stored as Text

    Due a ton of work importing .CSV files and I am always fighting numbers stored as text. Suggestions? When you do lookups the error goes over to the results. I have multipled by one, converted to text, converted to value and used data text to columns...What a pain

This Week's Hot Topics

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
Top