Description:
Microsoft Office Excel newsgroup.
|
|
|
Creating a form -
|
| |
Hi would anyone steer me in the right direction please. I do not have access, only Microsoft exel 2003 I have followed the threats on how to create a form, but will require it modified slightly. (g).
|
|
|
sending email to several contacts?
|
| |
winxp(home), Office 2k, (excel, word), OLE Have a spread sheet that includes several contact with email address'. Would like to send a Word doc to several, but not all, contacts without sending one at a time. Is there a way to do this? thanks, L.
|
|
|
Columnwidth
|
| |
Some of my cells contain al lot of text. I want to set my columnwidth to 75, but my text still expands the cells next to the text-cell... Is there a way to keep all text visible and to set the columnwidth to 75 (the cell highth should change to get all text in 1 cell) Can somebody please explain???... more »
|
|
|
Fiscal Year Formula
|
| |
I have this formula below that deals with finding calendar year. I need a formula that does the same thing but for Fiscal Year (7/1/09 - 6/30/10). =SUMPRODUCT((YEAR(A6:A100)=200 9)*(B6:B100="u")*C6:C100) Can anyone help? Would truly appreciate it!!! Thank you mePenny
|
|
|
Conditional format 2007 - is this easy?
|
| |
In prior versions, I would easily have been able to do the below. But how do I do it in 2007 Excel? I really cannot figure it out... Situation: I have a table; 5 columns, X rows. Column 4 contains a date (dd-MM-yyyy) or is blank (I have received no date to enter from client). If cell in column 4 i blank or date is later than TODAY(), I want all cells... more »
|
|
|
Convert excel file to xml
|
| |
I need to convert excel data into an xml file. I use Excel 2003. Most help I can find suggests using an existing xml file to create an xml map, and then taking things from there. Since I haven't got as far as creating an xml file, I can't do that. Is there a simple way to convert excel data to an xml format?... more »
|
|
|
Excel 2007 exits without asking if I want to save
|
| |
Hi All, I just started using Excel 2007 recently. I notice it exits when I keys in Alt-F4, without confirming if I want to save, even if I had made changes to the workbook. Is there an option which I can set and make Excel 2007 verify if the user, wants to save before exiting? This is the default in earlier Excel versions.... more »
|
|
|
Folder/Directory listings saved in Excel?
|
| |
Is it possible to save (to a file) a listing of the contents of a folder or directory? This would be useful for comparing names of files in say two different folders. It would also be good to save other attributes for the files - not just the names. I know there are non-MS downloads available to do... more »
|
|
|
|
