Rank Function returns "#N/A"

[ndshep]

Basically, I am using the Rank function on a column of cells with value
that are numbers. However, in order to make the numbers look the wa
that I wanted, I used =TEXT(number,"#,##0").

I'm guessing that RANK does not work on numbers that have had thei
format changed by the TEXT() function. Can anyone suggest a way aroun
this?

THANKS! My first post

 

[jeff]

Hi,

Keep them as numbers and use custom format #,##0

jeff