General

NOW() help
I want cell F5 to insert NOW() when D5 has a value entered Not sure what the formula looks like Cheers!!! ... 15 Apr 2010 01:34

Used to return a worke sheet to origanan values
Help please hoe hard can a one word answer be thanks ... 15 Apr 2010 18:07

VLOOKUP just returns formula
Help, my VLOOKUP is just putting the formula into the cell. =VLOOKUP(A13,'Tasks'!A2:D10,2,FALSE) Where A13 is on same worksheet as the lookup cell. What am I doing wrong? ... 14 Apr 2010 23:23

pop up calender
Is it possible to attach the pop up calender to the worksheet to be able to share or email Or am I using the wrong one and there is another? Cheers!! ... 14 Apr 2010 22:17

Cell fill color changes by itself
I have a user who has excel worksheets that they use fill colors. These are colors that they use all the time. Suddenly when she opens the sheets, the colors change by themselves even though no one has changed them. When another user opens the same document, they are the correct colors. It seems random as s... 14 Apr 2010 18:57

Is there a way to auto save at an interval? Not just AutoRecover.
I want to set Excel or any Office document to auto save at a set interval. Not just autorecover. ... 15 Apr 2010 11:24

How do i do an eblast from an excel spreadsheet, that has email's
i want to do an eblast from a column of email addresses i have in an excel spreadsheet ... 14 Apr 2010 17:49

WORKDAY function available?
I'm using Excel 2003 SP3. I have a need to use the WORKDAY function. Microsoft suggests it's available to me in my Excel version (http:// office.microsoft.com/en-us/excel/HP052093391033.aspx). However, when I try to use it I get a #NAME? error and I can't seem to find any reference to such a function in the app. ... 16 Apr 2010 10:35

Allow selection of Validation List in a Protected Cell
Using XL 2003, is it possible to lock a cell, yet be able to allow a user to make a change to a Validation dropdown list? I cant figure out how to allow this. Thanks, Tonso ... 14 Apr 2010 16:42

converting date to text
Hi , I would like to convert my date which is formatted as mm/dd/yy to a text format but i dont want to change the way the date looks. Currently every time i convert it to a text the date turns into a number. Can someone help me please ... 14 Apr 2010 18:57