|
|
Date Value & Date Format by
Denny Leung
Dear all,
In a cell, I type a sentence combining text and a date.
However, the date turns out a value instead of current
date.
="The profit of selling...
|
September 17th, 2003 05:18 AM
by Mike
|
2 |
300 |
|
|
|
|
2 |
352 |
|
|
Impossible Matrix by
Steve
Hi, I think I have been asked to do the impossible.
I need to write a macro that will give me a matrix of 20
names over 6 days.
There will be 2 groups of 10....
|
|
1 |
376 |
|
|
|
|
0 |
1,013 |
|
|
Problem with Date by
Denny
Dear all,
I've a problem with date when I input a cell with text and
a date.
I input:
="The profit of selling tickets as at" & NOW()
Return:
=The profit of...
|
September 17th, 2003 07:08 AM
by acw
|
1 |
332 |
|
|
matching values by
Donna Kostellar
I need to be able to look up a value from 1 cell in a
range of cells to find if there is a match and where the
match is
Can anybody help
Thanks
Donna
|
|
1 |
325 |
|
|
Solve for X by
Kunal
hello all!
How do I solve the below equation in excel?
+ + + + = 0
Thanks!
Kunal
|
September 17th, 2003 10:11 AM
by mows
|
5 |
362 |
|
|
AutoFill On Inserted Rows by
Aman
When inserting rows, is there a way to autofill data from
the row above or below? I have a simple autosum formula
on each row -- if I insert another row, I'd...
|
|
1 |
345 |
|
|
Sharing Workbooks by
Tim Hagedorn
I have a pretty elaborate workbook set up that is keeping
track of my inventory, sales, production, etc....
My problem is that I share this workbook w/ 2 of...
|
September 17th, 2003 11:58 AM
by BARB
|
2 |
355 |
|
|
lookup formulas by
Marian
I have a lookup formula working just fine as long as what
I want it to look up is there. My problem is that when
the number I want it to look for is not on...
|
September 17th, 2003 12:06 PM
by barb
|
2 |
341 |
|
|
combined cell by
bayanbaru
I have a huge file but with only 2 column. Column A is the
serial number and column B is description. I need to
combined the all description that has the same...
|
|
1 |
321 |
|
|
|
September 17th, 2003 12:20 PM
by Tobit
|
2 |
762 |
|
|
Macros in XP vs 2000 by
Peter
Having created a macro in a spreadsheet using Windows
Office Excel XP, I send it via email to my office, to
continue working on it, & macro will not run (at...
|
|
1 |
277 |
|
|
Change in time where text is involved by
Jill
I am working on a report where I am trying to show the
amount of time that passed between when we received a
completed contract and when the installlation...
|
September 17th, 2003 12:43 PM
by Michael
|
1 |
705 |
|
|
Date Format problem by
Nishant
Dear All,
Please suggest me the solution of my problem,
as i m handling data for 60,000 in no.Some body in data
entry has enter the date in a cell in gernal...
|
|
2 |
499 |
|
|
Using Sheet Name In Cells by
Paul Moles
In Excel Xp how do I get a cell to show the sheet
name,alternatively can I get the sheet name to show the
contents of a cell.
|
|
2 |
297 |
|
|
generating random numbers by
Roger
Is there a way (or formula) to generate a random number in
a cell? If so, can I specify the range I want the random
number to fall into, e.g., 1 through 6, 0...
|
September 17th, 2003 01:48 PM
by Roger
|
2 |
526 |
|
|
multiple field returns by
Ian P
I have a list of around 1000 names, separated into first
name in one cell, and surname in the next, with an
employee number in the third.
I need to create a...
|
|
1 |
457 |
|
|
concatenate question by
jr
I would like to concatenate some cells where the result
will be the first letter of one cell and the whole word of
the second cell. John + Smith = jsmith. Is...
|
|
1 |
283 |
|
|
Table Formula by
user21
Thank you very much. It was very helpful.
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post...
|
September 17th, 2003 02:04 PM
by Max
|
1 |
417 |