I was wondering if it were possible to restrict the values that can be
entered into a cell (which I know can be done) but to allow for the
available options to be displayed when the user has the cell selected
(a-la combobox) without adding a new form to my worksheet or inserting

I have excel work sheet in Excel 2002. It has data being entered vertically
in cells like this
     1
     2

Is it possible to write a macro to format a cell with the following format
$-100 if the cell has a negative number.  The following format in excel for
negative numbers is the following: -$100 or (100).
I know I would have to probably have to convert it to a text string in order

I have a .csv format file listing speed cameras, and the different speeds are
identified by two characters at the end of each line - 30,  40,  50 etc.  
I would like to create separate files for each speed, but Excel won't allow
me to cut/copy several lines to created a new ...

Had some nice code off a magazine to make the calendar
The code only allows you to do one date at a time, it would be nice if
you could just click on a cell and then click a date as often as you
want. Quicker to do Ctrl and Colon and then edit the dates as it is.

I have data set up such that I need to sum the value of a certain cell
and all its offsets
i.e.
I have data in B2, B12, B22, B32, B42 and I want to sum up only these

This was working a few days ago and now doesn't.  When you try and Edit a Web
query the web query box pops up with the correct web address, but you get a
message ... "Navigation to the webpage was cancelled". The Web Query does
work as it is on automatic refresh in the background ...

I know this is probably something more suited to a database, but I
want to try add this functionality into an existing spreadsheet I
already use.
I have a worksheet for each customer which contains contact details

Anyone have any idea on how I can make Excel sum up the displayed values of
several yperlink cells?

I have merged cells to make a larger area to input text, however, it
wont let me wrap text. It works fine when I dont merge the cells.
Does anybody know how to do this (or if it's possible)?
Cheers

Can you help me in finding a template where we as a department can add
our names for vacation some template basicaly?
Thanks & Regards
Raj

please can someone help me, i have just migrated to vista business ultimate
and use office 2007, when i now try to open certain files in Excel both in
the the new .format and .xls some will not open and the program freezes, i
need to sort out urgently any help greatly appreciated

I'm trying to use the web query function.
When I choose data/ import external data/new web query only my home
page comes up. I cant paste a new URL in the address bar of the edit
web query window. I can highlight and type in a URL. Any way I can

I have created a small spreadsheet in Excel XP. I have hidden all the
unwanted columns and rows and it prints ok. However, when trying to email,
all the unused columns and rows are still present (though hidden) creating a
very large file too large to send. How do I limit the size ...

I have two Excel 2003 yearly Workbooks in the same directory and I require
one of them to extract data from the other.
Basically, the second workbook (which is a summary of the first workbook)
has to simply extract and display the values from 48 cells in the first