FORMULA Sorts neg numbers as positive..
 

hi, not sure about math for doing a reverse sort, with the following example
small numbers turn to large.., with a reciprocol type formula and vice-versa,
using: =TEXT(10^3/DB841,"0000")

tested for numbers pos 1-1000/(4 places) & neg numers, negs come up neg,
but do not sort to bottom as neg (Problem is they are sorting same as/mixed
in with positive numbers),
output examples: (sorts to same order)
31 0032
-29 -0048 (sorts as if "-" sign not there
29 0048
19 0053

sorting formula example:
=IF($DB$20,TEXT(10^3/DB9,"0000"),9)&IF($DA$20,TEXT(10^3/DA9,"0000"),9)& ...

FORMULA Sorts neg numbers as positive..
 

What are your sort parameters? If you were sorting Z-A instead of A-Z
then the sort you've listed is working correctly. Bear in mind that
textual representations of numbers is going to sort differently than
the numbers themselves.

Dave O
Eschew obfuscation

FORMULA Sorts neg numbers as positive..
 

If your output examples are still the results of formulas then they will not
sort because the formuals will always recalculate back to the original
result.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Nastech" wrote in message
...
hi, not sure about math for doing a reverse sort, with the following
example
small numbers turn to large.., with a reciprocol type formula and
vice-versa,
using: =TEXT(10^3/DB841,"0000")

tested for numbers pos 1-1000/(4 places) & neg numers, negs come up neg,
but do not sort to bottom as neg (Problem is they are sorting same
as/mixed
in with positive numbers),
output examples: (sorts to same order)
31 0032
-29 -0048 (sorts as if "-" sign not there
29 0048
19 0053

sorting formula example:
=IF($DB$20,TEXT(10^3/DB9,"0000"),9)&IF($DA$20,TEXT(10^3/DA9,"0000"),9)&
...