sort

[vip7346]

Hi:
Help !!! How to find all the control or formula to prevent my sheet t
sort correctly ? I downloaded my bank statement and tried to sort b
check amount and it doesn't work !!

 

[support]

I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consultin

 

[Mark E Philpot]

If you downloaded your bank statement (which I have never
done mainly because there is never more than 95 cents,
after pay day, in it), wouldn't it be a text file?

Make sure you select the entire range to sort. If you have
objects on the sheet, this may intere fere with the sort.
Goto Tools > Options > View tab then click the radion
button to hide all objects. Sort you page then don't
forget to show all placeholders. It is better to put your
placeholders - buttons - away from the sort area.

regards
Mark E. Philpot
See http://au.geocities.com/excelmarksway for some nifty
utilities.

 

[Debra Dalgleish]

The numbers are sorting like this:

1
10
2

they may be text, instead of real numbers. There are techniques on my
web site that you can use to convert the text numbers to real numbers:

http://www.contextures.com/xlDataEntry03.html