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
-~----------~----~----~----~------~----~------~--~---
