General

.csv files
I have a .csv file created from Excel. In one of the fields the value is in scientific notation (for example 2.20511E+11) for each value. When I load the .csv file in Excel and highlight any of the values the correct number comes up on the formula bar. I have to read the .csv file provided in another program... 25 Jan 2010 17:23

Inserting shapes on a diagnal plane.
I am creating crossword problems and creating solution pages. I can not figure out how to insert a shape on the diagnal. Pls help. -- Thank you, Sam ... 26 Jan 2010 13:14

How do I group multiple files with excel to export to other users?
I have a folder on my desktop that contains the following: 1. An excel file that serves as a master index of the 892 pdf files that are contained in the same folder. 2. 892 PDF files, each with file names similar to: "ABCD.pdf", "TYRD.pdf", "HRTY.pdf", and so on. What I want to be able to do is the follo... 25 Jan 2010 16:15

Macro protection problems
I have about 20 worksheets in a workbook. I am using a macro to protect them all. One worksheet has a "control" panel with some command buttons. When I protect the ws containing the control panel, the buttons can still be pushed even though the cells are protected. Is there a way to protect the buttons too? ... 25 Jan 2010 16:15

data lookup
Here is my problem, I have a database with an assortment of data in a that takes place on many multiple days, and on each day i have multilple entries, and this database grows everyday, i.e. Date Time Amount category 1/1/10 1:00 x y 1/1/10 2:00 x y 1/1/10 3:00... 25 Jan 2010 16:15

Strange Macro name problem
When I go to TOOLS > MACRO > MACROS, all the macro names now appear with the workbook name plus a module # proceeding the macro name like this below: Sched vs CLSD with Costs 2009-12 w FY10 WBS_FIX CHART.xls'!Module6.Clear_data Now I can't even see the macro names unless I click on it and move the cursor to t... 25 Jan 2010 20:45

command buttons disappear when I move worksheet 2007
Excel 2007 - When I move my worksheet containg command buttons that run VB code to another workbook, the buttons disappear. How can I make the buttons move with the worksheet? ... 25 Jan 2010 16:15

Sorting Tables in Excel 2003?
I'm having a hard time figuring out how to sort tables that consist of more than one row in Excel 2003. It is like a checklist of things that need to be done, but in date order. Some dates have more than one task, so some tables have more rows than others and I need to figure out how to sort everything in date ... 25 Jan 2010 16:15

how do i get rid of the preview pane when opening an Excel 2003?
Having just reinstalled Office 2003 following a system crash, I now get a preview pane on the 'open file' box, which just says 'preview not available' when I click on any xls file. Does anybody know how to get rid of this? ... 25 Jan 2010 16:15

How do I change a drop down list?
I have been trying to change a drop down list for ages now. I follow the directions that I have, exactly, but can not seem to make the changes necessary. I have followed the edit drop downs explaination, and it still wont change. I can't even see to remove the drop down list and start fresh. Any help would ... 25 Jan 2010 11:41