Home

Numerical Sort Problem

Pattycake
Regular Visitor

I have a small worksheet that has first name, last name, address, phone and email. I am trying to sort numerically by the address, i.e. 2899 East 144th Avenue #101 Brighton MD 04001. All entries in that column are NUMBERS. When I sort A-Z I get a column sorted different than the original but still not correct. I have tried changing the entries in that column to TEXT instead but get the same exact results. All cells are the same height.  I can go to different worksheets with basically the same layout and they sort correctly.  This one has me more than baffled. Even changed the "#" to "Unit" but that did not help either. Any clues for me to try now? Thanks.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies