You're welcome.
> Date: Fri, 24 Oct 2008 02:47:33 -0700
> Subject: $$Excel-Macros$$ Re: Sorting a column
> From: [EMAIL PROTECTED]
> To: excel-macros@googlegroups.com
>
>
> Thanks Dave
>
> Has worked a charm! I have formatted the cells that data shall be
> placed into (via macro) in advance, so should not be a problem in the
> future.
>
> Thank you kindly once again!
>
> On Oct 23, 5:28 pm, Dave Bonallack <[EMAIL PROTECTED]> wrote:
> > Hi,
> > Just formatting a cell as number after the cell has received data, does not
> > change the format of the data.
> >
> > If all your data is numeric, then follow these steps to actually change
> > your data to numbers:
> >
> > 1. Select Range A71:A1000
> > 2. Format as number.
> > 3. Enter 1 into an unused cell, then right-click that cell, and select Copy.
> > 4. Select Range A71:A1000, then right-click and select Paste Special.
> > 5. Select Multiply from the Operation options.
> > 6. Click OK.
> >
> > Now run your macro again, and it should sort as you want.
> >
> > If your data is a mix of numbers and letters, eg 1234ABCD, then the
> > operation is more complex, but still possible.
> >
> > Regards - Dave.
> >
> >
> >
> >
> >
> > > Date: Thu, 23 Oct 2008 02:36:27 -0700
> > > Subject: $$Excel-Macros$$ Sorting a column
> > > From: [EMAIL PROTECTED]
> > > To: excel-macros@googlegroups.com
> >
> > > Hi All
> >
> > > I'm trying to code a worksheet so that when I press a button, it sorts
> > > the column in numerical order. I have been using the code
> >
> > > Private Sub commandbutton12_click()
> > > Range("A71:U1000").Select
> > > Selection.Sort Key1:=Range("A71"), Order1:=xlAscending,
> > > Header:=xlNo, _
> > > OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
> > > Range("A2").Select
> > > Call CommandButton1_Click
> > > End Sub
> >
> > > However, whether the cells are formatted as numbers, general or text,
> > > the numbers sort in the following manner
> >
> > > 1
> > > 10
> > > 2
> > > 20 etc
> >
> > > rather than
> >
> > > 1
> > > 2
> > > 10
> > > 20etc
> >
> > > How can I sort them as per the second manner please?
> >
> > > Many thanks in advance
> >
> > _________________________________________________________________- Hide
> > quoted text -
> >
> > - Show quoted text -
>
> >
_________________________________________________________________
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
