LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Sorting texts and numbers as if it was all numbers

The question you posted there doesn't make much sense to me. The sample
data you show is already sorted on both columns from what I can tell.

--
Regards,
Tom Ogilvy


"Werner" wrote in
message ...

I've done a search in another forum, ozgrid.com forum and I have found a
post going back to july 20th 2004. Derk, an excel expert, has posted
back then an amazing search macro that works like magic. It resolved
instanly all my problems in an efficient way. Here's the link :


http://www.ozgrid.com/forum/showthre...t+text+numbers

I say thanks to Derk for that code!

Werner


--
Werner
------------------------------------------------------------------------
Werner's Profile:

http://www.excelforum.com/member.php...o&userid=24304
View this thread: http://www.excelforum.com/showthread...hreadid=385246



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 numbers and numbers that contain text in excel MZ Excel Discussion (Misc queries) 3 November 25th 09 07:45 AM
Extract texts & numbers from one cell into four cells Ed Excel Discussion (Misc queries) 3 January 25th 08 04:57 AM
List of unique texts and numbers vsoler Excel Worksheet Functions 7 May 19th 07 06:47 PM
Conditional Formatting : Numbers & Texts Conflict nayinky Excel Worksheet Functions 3 August 8th 06 07:15 AM
convert numbers to texts sampath Excel Worksheet Functions 1 December 2nd 04 01:18 PM


All times are GMT +1. The time now is 09:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"