| Thread | Last Post | Replies |
|
| Non-numeric Data | 13 Dec 2005 01:16 GMT | 12 |
I'm trying to run descriptive statistics on data that has been copied and pasted from a .csv file but it says some of the data is non numeric. i've used the view cell contents download, i've tried trim and clean, i've tried multiplying everything by 1, all without success and i'm ...
|
| Error 2042 | 13 Dec 2005 00:12 GMT | 3 |
Dear Guru, I have this Dim nameInput as String nameInput = InputBox("Please specify the value of NAME that you want to
|
| Newbie question....about auto multiplications of colum data | 12 Dec 2005 23:48 GMT | 1 |
Hi , i'm a bit of a newbie to excel , but i have a list of data 50 lines , basically its has two colums , colum 1 is a price , colum 2 is the qty . but i want to add a colum 3 that automatically multiplys for each line colum 1 prices by the colums 2 qty but i can't work out the ...
|
| Can I make a database in Word with Excel Data | 12 Dec 2005 21:27 GMT | 5 |
I know this may be a "DUH" question, but... I am making a list of area dentists that I have copied and pasted of of the Dex website into Excel. I am wondering if I can take this inf and make a database in Word for printing address labels. Does anyon
|
| FORMULAS | 12 Dec 2005 21:05 GMT | 2 |
I need to insert more lines in my database but I don't know how to copy down the formula so it stays the same. Thank you.
|
| "A document with the name *.xls is already open" error message | 12 Dec 2005 20:53 GMT | 1 |
I've just started getting the above error when I try to open an Excel spreedsheet. Anybody have any idea what's causing this?
|
| Data>Validation Question | 12 Dec 2005 20:06 GMT | 2 |
Hello and greetings from South Texas (very cold). I've created a simple spreadsheet report with six different categories (columns). In two of those categories I implemented drop down lists using Data>Validation>List, etc. Initially it worked like it was supposed to therefore ...
|
| border format causing the doc to be hundreds of pages long | 12 Dec 2005 19:52 GMT | 8 |
I have a spreadsheet that is about 6 pages long. Evidently, someone has applied a border to some cells , that seem to go on and on forever. Therefore, the worksheet looks to be hundreds and hundreds of pages... all
|
| *.csv Format Saving Problem | 12 Dec 2005 19:44 GMT | 1 |
New at this. I have an Excel spreadsheet that I wish to save in .csv format. It never saves the formatting like Underlines, Bolds, etc., no matter what I do.
|
| Formula to/from other sheet | 12 Dec 2005 19:14 GMT | 5 |
I have a sheet named "reports". In the cell C9 I need to have a value taken from 12 sheets named "June 2005", "July 2005" .. Until I reach sheet "May 2006" The value I need has to be calculated from 3 different cells:
|
| How to change an excel sheet into a picture? | 12 Dec 2005 19:06 GMT | 2 |
1. I get jibberish when I try to insert the excel spreadsheet into the word document. The document originated as a template chart. I'm wondering if that is messing things up. I have done this operation before at another office but am wondering if the
|
| ISBN problem | 12 Dec 2005 17:28 GMT | 2 |
I'm having a problem with my product catalogue with my online store. download the catalogue to .csv file and open it in excel. When I ope the file it removes the zero from the ISBN number. (eg 07654321 become 7654321). This is becoming a big pain.
|
| What converter do I need to change my QPW files to work in Excel 2 | 12 Dec 2005 17:13 GMT | 1 |
I had Quattro Pro (about 2003 -2004) on my computer when my hard drive crashed now I have Excel 2003. What converter do I need to change my QPW files to work in Excel 2003?
|
| how to calculate an age from 10/8/1943 | 12 Dec 2005 17:12 GMT | 2 |
i have members birth dates in Exel an whant to display them diffrently at present they are like this 10/8/1943, 1/3/1943. would like them to look like 62yrs 15days
|
| Help on autofilter sort ascending and descending! | 12 Dec 2005 14:42 GMT | 2 |
After I select sort ascending from autofilter, is there anyway to sort back to the original?
|