You're question isn't very clear. You may want to clarify it a bit.

"nastech" wrote:

Hi, have a project where intensive sort formula work needs rest of formula
ascending (for that worker column), but need to descending sort item within.
sample of what have: (thanks)

Problem is getting a number column to sort in descending order (i.e. make a
negative number so an "Ascending" sort will handle the other parameters as
ascending). 1st part ascending, only 2nd part needs change to descending.

=IF($Z$2=1,AA9,9)&IF($CU$2=1,-CU9*10^-11,9)

have used variations with TEXT(CU9,"00000000000") and trying to put the
negative sign around different spots, not getting to work.