Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

xlSortTextAsNumbers Excel 2003

Status
Not open for further replies.

jorlwebb

Technical User
Aug 27, 2007
1
US
I regularily use the Sort function in Excel 2003 and everytime I have to click through the Sort Warning box that asks whether to sort text that looks like numbers as numbers or not. I want to sort text that looks like numbers as numbers everytime. Also, just doing "Copy -> Paste Special -> Multiply" will not work in my case because it reformats the information I'm using. I don't want that.

Is there a way to make an Excel add-on or some kind of global option macro that will auto-select "DataOption1: =xlSortTextAsNumbers" everytime I try to manually sort a table? I'm thinking of some kind of "On Sort" action, but any solution would be welcome.

Also, this does not appear to be a simple option I can choose in the Options menus.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top