Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert a string value to numeric and sort
With a specific function I created a list as following 15 16 15,5 15,5 What I want is to put those numbers in order of sequence. First I noticed that my 15,5 values are not integers but strings. So need to make integers of those. If I combine my formula with the VA function I come to the following: Cells(y, 10) = VAL(VLOOKUPNTH(Cells(1, 8), Range("b2:e10"), 2, y)) It looks like if my formula is correct but the result is not correc and as following: 15 15 15 16 The Val function stops as soon as it recognizes a non-numeric value How I can I correct this???? Please help me out here -- marioma ----------------------------------------------------------------------- mariomaf's Profile: http://www.excelforum.com/member.php...fo&userid=3009 View this thread: http://www.excelforum.com/showthread.php?threadid=49820 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert a string value to numeric and sort
Hi
When there are formulas returning numbers as string values, then modify them like =YourFormula*1 or =--(YourFormula) When you have converted formulas to values, then -format the range with string numbers as General -enter a number 1 into any free cell, and copy it; -select the range with your numbers, and then PasteSpecialMultiply. OK; -delete previously entered number 1. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "mariomaf" wrote in message ... With a specific function I created a list as following 15 16 15,5 15,5 What I want is to put those numbers in order of sequence. First I noticed that my 15,5 values are not integers but strings. So I need to make integers of those. If I combine my formula with the VAL function I come to the following: Cells(y, 10) = VAL(VLOOKUPNTH(Cells(1, 8), Range("b2:e10"), 2, y)) It looks like if my formula is correct but the result is not correct and as following: 15 15 15 16 The Val function stops as soon as it recognizes a non-numeric value. How I can I correct this???? Please help me out here. -- mariomaf ------------------------------------------------------------------------ mariomaf's Profile: http://www.excelforum.com/member.php...o&userid=30098 View this thread: http://www.excelforum.com/showthread...hreadid=498201 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert a string value to numeric and sort
Amazing!!! Life's easy when you've made it :-) Thanks -- mariomaf ------------------------------------------------------------------------ mariomaf's Profile: http://www.excelforum.com/member.php...o&userid=30098 View this thread: http://www.excelforum.com/showthread...hreadid=498201 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric? | Excel Worksheet Functions | |||
How do I replace last numeric string from a alphanumeric string? | Excel Discussion (Misc queries) | |||
How do I convert numeric data to string format (without VBA)? | Excel Worksheet Functions | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) |