When I enter a date into a cell it always adds an = sign in front of the
date. Is there an option to stop this from happening?

I want to set up a cell with conditional validation. If an answer is (x) then
validation comes from d:2 if answer is (y) then validation comes from d:3.
Can excel do this?

Excel easily calculates IRRs where cash initially is invested/spent and then
followed by a series of incomes.  However, I have situation where I need to
calculate IRR where the cash invested is spread over a number of years,
rather than being invested as a lump sum up front.  ...

I have the following formula in Range A8:A30-
=IF('Mix Check'!U8="","",'Mix Check'!U8&'Mix Check'!N8&'Mix Check'!
O8&'Mix Check'!P8&'Mix Check'!Q8&'Mix Check'!R8&'Mix Check'!S8&'Mix
Check'!T8)

I have a project with two milestones, but I only know the date for the second
milestone.  To derive the date for the first milestone, I know that it must
occur ~46 days prior to the date of the second milestone.  However, the first
milestone must always occur on a Monday.

I'm trying to use Excel to make a converter between GMT and EST/EST DST.

Anyone had problems with this addin lately???
I've been running this it for a few years now with no problems until
yesterday when clicking on 'Update Quotes' brings up the message
'Failed to get requested data'. Network connection is fine so thought

How do you convert a UK date format to a US date format to sort by date?  
i.e. dd/mm/yyyy to mm/dd/yyyy

I'm trying to find a way for one column in a seperate spreadsheet to be
automatically popualated by the text that is input onto another spreadsheet.
I am not taking data from one single spreadsheet but taking data from
several (100+) spreadsheets setup for individual users.

Is there some way to give a formula with a name without having to
manually retype the whole thing? I have a big formula that works
perfectly, and I'd like to define it as a name so I can use the
formula in several different places. I can't paste it in the Define

Everytime I started my Excel 2007 in Vista, I always get the following error
message:
Microsoft Visual Basic
Run-time error '-2147352565 (8002000b)':

How could I express the following as a Text string
I have 3 Names in A1:A3 (Jim; Bob; Mike); in B1:B3 is a value of
either 1 or 0 (1;0;1). I wish to construct an opening statement
depending if the values in B1:B3 are 1, so for example if B1=1;B2=0

In a worksheet, I have 2 tables. 1 gives the price for freighting
different sorts of material. The other lists where the material is
needed. EG
DirtA: $100

I know that there is a "date and time stamp" in the Header and Footer section
but I'm running out of margin to do the Header and Footer.
How can I have a date and time stamp in the cell for printing purpose?
I've tried =now(), but the thing is now() update only when the sheet is

I have about 4000 rows and need a new, blank row every 12 rows.