General

How do I sort a column using the last number in the cell?
I need to sort a spreadsheet by using the last digit in a column that has department numbers. EX: 300009 300006 300004 Thank you! ... 7 Apr 2010 16:54

=CELL("filename") returns #VALUE!
Dear Friends, When I use =CELL("filename") in Turkish regional style, it gives #VALUE! error but if I change the settings to USA, it works! Why? And how I can solve this ? PS: I use an english office 2007 and I use the formulas in English, no problem with any of them. But I got error with this. Thanks &... 8 Apr 2010 15:12

Custom Views
I see from other posts that there is no way to copy a custom view from one worksheet to another (aside from using "save as" as a work around). My next question then is there any way to disply what settings are inherent in a custom view so that I can re-create it in another sheet? Thanks, Parls ... 7 Apr 2010 19:11

moving data from one sheet to another
I am trying to move data from one line on one sheet to multiple lines on another. Basically taking a customer list and converting it to 4x6 notecards for easy reference on the road. When I try to copy the formula down the second page it skips 10 lines at a time. the only thing that I have been able to do is man... 7 Apr 2010 16:54

How do you randomly generate numbers in Excel 2007?
How do you randomly generate numbers from 1 to 84 without duplicates in Excel 2007? ... 7 Apr 2010 16:54

WorkSheet Cell Precedents?
Excel2003 ... I wish to delete a few WorkSheets in a 40mg WorkBook ... However, I do not wish to delete if any of the cells are Precedent for other WorkSheets. I know how to do this on a cell basis with the "Auditing" ToolBar ... but is there a way to do this on a WorkSheet basis. Thanks ... Kha ... 7 Apr 2010 15:47

Disable auto (date) format?
In A3, I have a formula of the form =A1/A2/24, where A2 is time (date serial number) formatted h:mm:ss. (A1 is a number formatted as General.) When A3 is formatted as General, Excel changes the format to h:mm:ss every time I edit A3. I have to change the format back to General manually, which is a nuisance. ... 7 Apr 2010 20:19

opening files error
For some reason, none of my Excel 2003 files will open when I double-click them from a folder or desktop shortcut - the only way I can open a file is to start Excel, click open and browse for the file I want. As a side note, I was recently attempting to get my workbooks to open in separate windows as opposed ... 7 Apr 2010 15:47

i want to know formulas in MS-Excel2003
Hai guys, Can anyone help me out i need a formula in Excel2003 like with the help of datas in two different cells i wanna give value to 3rd cell but i dont want to type anything in that cell. Its much like Circular Reference. e.g: if A1=1, B1=1 then i wanna give C1=1 but dont wanna type anything in C1... 7 Apr 2010 15:47

I need to show a % of a number
I have 8 categories that is being graded from 1-5 and each represents a different % value see my example: Category A = 15% Each individual can rate a question from 1-5 (5 being the best & carrying the whole 15%) I want to show where if you graded Question #1 a 5 = 15% versus if you graded it a 3 = X% -- I ... 11 Apr 2010 04:45