Hi
How I store 4'5'' (4 foot and 5 inches) in a cell and use it i
callculations.
Thanks

I have a sheet in which i want to validate the values that are filled
in:  possible must be the numbers from 0 to 100 and the value  "absent".
How do i do this?

I have a blank column which I want to fill with the results of a
concatenation between two other columns...could someone give me the
general steps on how to do this (doesn't have to be concatenation
operation, could also be a sum between values of columns, for example).

I am trying to save a worksheet to a CD for a backup. I go to save as and
save in my E drive and I get "incorrect function." I then press the only
thing I can press, OK, and I get "you do not have access to this folder
'E:\', see your administrator for access to this folder." ...

I have two workbook tables (Two different workbooks) with two matching column
names.  What I wish to do is to merge values from one table to another, but
ONLY for those records inwhich these two columns have matching values.  Would
this be possible?

Ok i know this is going to sound stupid but...
I was writting a macro to format a report and wanted to add it to th
tools drop down menu; however whilst i was doing so i stuffed up th
code and instead have deleted the "Tools" option from the command bar

I have been working a spreadsheet and I just noticed that in one of my
rows which has fractions in it (for example, 08/1, 11/1, 12/1) a few of
the cells have been converted into a date.
Like, 8/1 is now 8/1/2006 and in the cell it comes up as 1-Aug, 11/1 is

I have a problem with adding up rows of numbers.
I have "dragged" the mouse across the row of figures, then click the Autosum
icon but the row does not add up correctly. It shows as a format :-
=SUM(B1:AI1).

is there a method in excel where I can convert a row of entires into a
column
example...
can this -->

I searched the web and newsgroups but couldn't find a way
to do this.  I would like to search multiple sheets in a
particular column and paste the complete row containing
the searched word into a new sheet.

ok using a treadmill
I do 1.54 miles in 20 minutes
is it possible to use a formula to find an average speed/average pace?
Thanks Rob

When I open a spreadsheet (old or new) it takes about 15 seconds to load, I
seem to recall getting an allmost instant opening on them, and I think it
has just slowly increased over a period of time. I have done all the usual
defrag,virus checks, emptied cache/cookies temp folders ...

   I have a form "F" on which there is a command button "B" and a textboxe
"T". "S" is another string variable defined somewhere else outside the form.
I want to have the value of the cell A1 in the sheet where its name is given
in S changed to the value of T, what should I ...

I had a job once in Data Processing where I would take a paper form and input
the data in into a computer program then push "enter" and it would add that
data to pre-existing data that had previously been entered.  Understand?  I
have a forms that I need to  enter into Excell so ...

I USE EXCEL WORKSHEET TO MAINTAIN EMPLOYEES VISA EXPIRY, LICENSE EXPIRY ETC.
WILL ANYONE TELL ME HOW TO MAKE A FORMULAE TO USE THE EXPIRY DATE COLUMN TO
REMIND ME AND SEND SOME KIND OF REMINDERS ?