recent postings not seen

[Guest]

I submitted a question earlier this morning (6/7) and received a message
saying someone had responded, but I am not able to see any postings after
6/5. What is the problem?

 

[PCLIVE]

I don't know if you see your post now, but the response was as follows:

It would have helped, you know, if you had also shown how you would
expect them to be sorted. I assume that you want 12345 to be sorted as
if it was 54321? If so, use the following formula next to your data
(assuming start from A2).

=SUMPRODUCT(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),
1)*10^(ROW(INDIRECT("1:"&LEN(A2)))-1))

Sort by this column.

HTH
Kostis Vezerides


Regards,
Paul