Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Alphabetical list of Numbers are not correct!
I'm working with numbers in a column and some numbers are the same.
when I try to have the numbers accend in numeric order they are arranged wrong.. 26125 then 26126 then 26125 again. 506 will come before 0506. I want the numbers to line up like 0506,26125, 26125, 26126, 506. letter are no problem just the numbers. Any help would be greatly appreciated! |
#2
|
|||
|
|||
Hi Scott
the only way i can get the "numbers" to behave like you want them to is to enter them with a leading ' e.g. '0506 '26125 etc the ' doesn't show, but when i use data / sort to sort them they sort in the order you want. Hope this helps Cheers JulieD "scott" wrote in message ... I'm working with numbers in a column and some numbers are the same. when I try to have the numbers accend in numeric order they are arranged wrong.. 26125 then 26126 then 26125 again. 506 will come before 0506. I want the numbers to line up like 0506,26125, 26125, 26126, 506. letter are no problem just the numbers. Any help would be greatly appreciated! |
#3
|
|||
|
|||
hi,
I thing you have some of the numbers formated as text. excel sort numbers and text differently and when sorted togeather numbers first text last. check and correct the formats then try again this is the only explanation that would explain this unusual behavior. -----Original Message----- I'm working with numbers in a column and some numbers are the same. when I try to have the numbers accend in numeric order they are arranged wrong.. 26125 then 26126 then 26125 again. 506 will come before 0506. I want the numbers to line up like 0506,26125, 26125, 26126, 506. letter are no problem just the numbers. Any help would be greatly appreciated! . |
#4
|
|||
|
|||
Thanks Julie,
This did work...as long as I remember to put the ' in front of the numbers. Many Thanks, Scott "JulieD" wrote: Hi Scott the only way i can get the "numbers" to behave like you want them to is to enter them with a leading ' e.g. '0506 '26125 etc the ' doesn't show, but when i use data / sort to sort them they sort in the order you want. Hope this helps Cheers JulieD "scott" wrote in message ... I'm working with numbers in a column and some numbers are the same. when I try to have the numbers accend in numeric order they are arranged wrong.. 26125 then 26126 then 26125 again. 506 will come before 0506. I want the numbers to line up like 0506,26125, 26125, 26126, 506. letter are no problem just the numbers. Any help would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing firsts two numbers from a list of #s | Excel Worksheet Functions | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Random list (1-45) without repeating numbers? | Excel Worksheet Functions | |||
Make Data validation List Alphabetical?? | Excel Worksheet Functions | |||
creating pages from an alphabetical list | Excel Worksheet Functions |