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)& ...

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

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)&
...