text and number

When I save a text col (all the items are numeric) then save as CSV (MS-dos) it converts the items to numbers. I have a worksheet where I use a Vlookup and IF functions, When IF functions the results are numbers, but in a text form. IN other words the result is coming from a text cell are...

I will have column information that will list entries like this: DD, DD9, SD, LHR, HIGHLIFT BOTTOM SECTION, DD, D9 DD, PVC DD, SD, LHR, HIGHLIFT Is there a way to run a SUMIF or other formula on these and separate the values from the commas? I am familiar with Text to Columns but I will be...

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 didn't realize there is a limit on the maximum number allowed in all versions of Excel (15 digits long max).:rolleyes: I've made an error by manually entering loads of values only to discover that I lose the accuracy after the first 15 digits which are replaced by zeroes in affect. It was...

So I am trying to arrange a set of data in which there are certain codes that correspond to numeric values. Basically, I need to either find a way to assign text values, or to sort through a complex function that I am not sure how to compose. The values in decending order are as follows: 16M...

Hi I really need some help on this, I have been trying for ages to get a solution. I have attached the excel sheet to demonstrate my problem. To explain, I have a column which has a vlookup formula within to find a cost related to a job number on a separate sheet. The result/ value from the...