One click time
Mon, 6 Oct 2008 01:56:02 -0700
I know the question has been asked and the simple answer is ctrl - shift - :
to add time in a cell. Unfortunatly sometimes the easy solution is still
difficult. I would like to know how to click on a cell and have the time
appear. Because i do security patrols and my laptop is mounted in my vehicle.
It"s dif ...
|
adding same format for colunm
Sun, 5 Oct 2008 23:24:01 -0700
Thanks for those that helped me with my last time question. Would of replied
back on my original post but can't find it now. Anyway, the question now is.
How do i format a colunm for the time formula. =D2-D1 + (D2<D1). I have 35
more cells to do. Can it be done without doing each cell one at a time? ...
|
How can I stop a formula from executing based on a cell value?
Sun, 5 Oct 2008 10:31:00 -0700
I have a worksheet that gets a date from another worksheet and displays it in
a cell.
I want it to only update if another cells value is "Y", If the cells value
is "N", I want it to leave the displayed date the way it is and not update
the date from the other sheet. I have used an "IF A1=Y(formula)" but it ...
|
How Outlining w/o numbers possible?
Sun, 5 Oct 2008 15:00:03 +0530
I received a file wherein there are no numbers, but still it is outlined,
upto 8 levels. There are just 3 columns, 2nd col. has no header and as a
sample I give the first few rows' data:
<ProductCatalog> ProductCatalog
<CatalogHeader> 1..1 ProductCatalog/CatalogHeader
<Catalo ...
|
DDE problem between Word and Excel
Sat, 4 Oct 2008 23:20:18 -0700
For years I have been using Word programs (Office 2000 series) to access
Excel name and address data files to produce letters, mailing
labels, etc. Now, when executing a Word merge program, I am all of a sudden
receiving the message, "Waiting for Microsoft Excel to Accept DDE Commands."
The computer then hangs ...
|
budget columns
Sat, 4 Oct 2008 20:26:01 -0700
I need vertical columns automatically subtracting as entries are made with
balance at the bottom, like so:
A is text budget items, B / C / & D are Paycheck amounts. As item amounts
are entered, should auto subtract to balance cell farther down the column.
I've tried all afternoon (actually it's 8:20pm n ...
|
Converting values to text
Sat, 4 Oct 2008 20:26:42 +0100
I have a load of values which i want to convert to text, the text will
depend on the value. ie
If value=1, text = DOG
If value=2, text = CAT
If value=4, text = PIG
Thanks.
...
|
|
|
last value
Fri, 3 Oct 2008 22:38:01 -0700
Help me with a function which will return the value of the last cell >0 in a
series of non contiguous cells in the same row.
for example:
D I N S X AC AH
AM
1 2 1 3 0 0 0 0
=funct ...
|
Hidden Columns
Fri, 3 Oct 2008 21:43:00 -0700
Cannot open hidden columns by selecting the column adjacent to either side ...
|
how do I costumize the menu?
Fri, 3 Oct 2008 19:57:00 -0700
how can i activate the custumize tab in the microsoft word excel? ...
|
