FORMULA Sorts neg numbers as positive..

[Nastech]

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$2>0,TEXT(10^3/DB9,"0000"),9)&IF($DA$2>0,TEXT(10^3/DA9,"0000"),9)& ...

 

[Dave O]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk