$$Excel-Macros$$ Re: Sorting a column

2008-10-26 Thread Dave Bonallack
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

$$Excel-Macros$$ Re: Sorting a column

2008-10-24 Thread A . for . Andy
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

$$Excel-Macros$$ Re: Sorting a column

2008-10-23 Thread Nishant Jain
This will happen when your numbers are in text. If you can send me a file with example i can try Nishant On Oct 23, 2:36 pm, [EMAIL PROTECTED] wrote: 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

$$Excel-Macros$$ Re: Sorting a column

2008-10-23 Thread Dave Bonallack
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