Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tamesh
 
Posts: n/a
Default decimal sorting

Hi,

I have a spreadsheet with an inventory list. The inventory items all have
number associated with them (i.e. 1900.04). However Some of the inventory
has multiple items associate with the same originating number (i.e.
1900.04-15). Is there a way to sort it so that all the similar numbers stay
together (i.e. 1900.04, 1900.05, 1900.04-15) without sending the hyphenated
values to the bottom of the list after 2000 for example.

Thanks.
 
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
Formula for: Format Decimal places? nastech Excel Discussion (Misc queries) 16 November 4th 05 02:25 PM
Excel adds phantom decimal places: why? Dave O Excel Discussion (Misc queries) 1 August 16th 05 06:25 PM
sorting numbers more than one decimal Erin Excel Worksheet Functions 4 March 9th 05 07:19 PM
How do I override fixed decimal place settings in EXcel 2003? jroyv Excel Worksheet Functions 2 February 11th 05 06:07 PM
decimal point override does not work Sam Brauen Excel Discussion (Misc queries) 0 January 6th 05 05:29 PM


All times are GMT +1. The time now is 02:13 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"