Posted to microsoft.public.excel.misc

ezil

external usenet poster

Posts: 43

sorting numerical data

I need to sort a column say "c" which contains numerical data. When i press
"a to z sort" button the numerical data is sorted as alphabetical data i.e
it ignores positive and negative signs and after 10, the value 100 comes
and 20 then -20 then 200 like this. How to sort this data in ascending or
descending order?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sorting data using numerical list	Lyns	Excel Worksheet Functions	1	March 7th 07 06:13 AM
Sorting Numerical Values...	Smohrman	Excel Worksheet Functions	9	April 7th 06 07:58 AM
numerical data sort	brichwine	Excel Worksheet Functions	5	February 10th 06 06:32 PM
How do I total non-numerical data	asg2307	New Users to Excel	2	December 27th 05 09:27 PM
Non-numerical data in a pie chart	Gina O'Brien	Excel Discussion (Misc queries)	1	May 13th 05 01:41 PM

All times are GMT +1. The time now is 02:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us