I am building a questionnaire in Excel that others will need to fill in. For
one of the cells the respondent's answer should consist of at least 15 words.
Is there a way to build in such a validation of a cell in Excel?

If I have 3 (or 4, or 5, ...) values (x1,y1; x2,y2; x3; y3; etc) in a 2xN
array in Excel, how can I derive the formula (y=F(x)) for a simple smooth
curve that would pass through all of those points - so that I can calculate
the value of a new value of Y for a new value of X (not ...

Why does the word typed "true" automatically turn to ALL CAPS?
Also why does a foder named "con" cannot be created in Office?

I have been given the task of creating a spreadsheet of employees which will
flag 3-months before a certification is to expire,i.e., CPR,First
Aid,Firearms, etc.
Do I need to milestone the event or is there something easier. I am a

Sure hope somebody can help me with this problem.  I tried to open a
spreadsheet this morning, and it came up with file format is not valid
message. I found that I can open it in word, but the contents are actually a
word document that I haven't even looked at for a while.  I ...

Hi, All,
My apologies if this is an old topic, but my copy of Excel 2003 inserts a
'v' when I press 'm'. I therefore get 'vm'. The same thing happens with 'n'
and 'b', I get 'bn'

I worked on a Excel file in Outlook and closed it, saved the changes at the
prompt and later went looking for it. I cannot find it. I believe it went
into a "OLK" folder. I have tried all manner of searches and can only locate
5 xls files on my whole HD and I easily have 100+.

can any one help me to covert 12/10/1970 to years/months/days

Using Excel 2003
Column A is dates.  These dates plus 7 are being compared to the current
date to determine whether "overdue" gets displayed in Column D.  I'm using
the following IF statement:

I've got a number of spreadsheets of data from some experimental work. The
format is:
Column A: time of measurement (0, 0.5, 1, 1.5, 2, 2.5, 3, etc)
subsequent columns: Measurement values.

OK... so I had excel file open and did something I shouldn't have... then
like an idiot, I hit save and closed excel...
DOH
I screwed up... is there any way to locate the document in the guts of my

I want to be able to change the format, background colour and font, of
a cell dependent on the manually entered content of that cell.  I am
aware of Conditional Formatting, but this only gives me three options,
whereas I need three groups of three, i.e. if contents = A or B or C,

Hi, I have data for several human subjects and their data is set up in
an excel file so that all the data for person 1 takes up 15 rows,
person 2 the next 15 rows, etc.  I would like to make all of a single
person's data merged into one row horizontally, so that each human

have two columns range of numbers i need to list each number in the range
start   end
5        9
15      19

I have 4 computers with Office 2003 and XP pro.
The pixel height on 3 of the 4 computers for a row with Ariel and 10 pt font
is 12.75 pixels (microsoft standard)
on one computer that row height is 13.2 pixels.Any idea what has happened?