|
|
Hours and Minutes Data format by
Dave08
I am trying to format a cell so it displays Hours and minutes. I am entering
1:00 and desplaying 1/01/1900 12:00:00 AM. The formating on the cell is
HH:MM.
|
|
3 |
78 |
|
|
|
|
0 |
93 |
|
|
|
|
0 |
130 |
|
|
|
|
0 |
156 |
|
|
|
|
0 |
188 |
|
|
|
|
0 |
92 |
|
|
Number Problem by
Sandeep Jangra[_2_]
D'all,
In a column, I hav 16 digits numbers. But when I add 4 digit number after
last digit of that number becomes 4 zeros at last. e.g. 9503170011002910...
|
|
2 |
99 |
|
|
|
|
1 |
156 |
|
|
|
|
1 |
116 |
|
|
FORMULA WHICH IGNORES POSITIVE VALUES by
CHAKES
HI
I NEED KNOW IF THERE'S A SUM FORMULA {=SUM(A1:A4)} WHICH TOTALLY IGNORES
POSITIVE VALUES AND ADDS ONLY THE NEGATIVE VALUES?
EXAMPLE:
A1= -3
A2= -7
A3= ...
|
|
2 |
102 |
|
|
days calculation by
Yousoft
Hi All
The following formula is calculating the no of days without holidays, so I
want this formula in excel function...
|
|
3 |
151 |
|
|
Macro to update information if date changes by
Wundrfulthing
using Exel 2000..
I want excel to compare dates on two seperate worksheets and if the date on
the first is greater than the second to insert rows and than...
|
|
1 |
106 |
|
|
|
|
6 |
280 |
|
|
Prompt msg if the worksheet already exits by
Dee
Hi,
Below was my recorded macro . What shall i do to prompt user with a msg when
both worksheets "Shop 1" & "Shop 1 Pivot" already exits when click onto the...
|
|
2 |
120 |
|
|
splitting cells by
Bitter Clinger
I use Excel 2002 with XP Pro SP3. I seem to remember that in Excel '97 you
could split a cell, but I can't seem to be able find a way to do this in
Excel...
|
|
2 |
104 |
|
|
Email individual worksheets? by
Flambe
Hi! I am preparing to send out a sales report via email (not outlook). The
worksheets are labeled by month. I want to send out only the worksheet
labeled...
|
|
1 |
96 |
|
|
What happened to SHIFT+EDITCOPY PICTURE by
lappen
Where can I find the copy picture command that, in earlier Excel-versions was
found under SHIFT+EDIT, COPY PICTURE. A very handy function that I miss in
the...
|
November 7th, 2008 06:35 PM
by Nonie
|
1 |
190 |
|
|
|
|
1 |
115 |
|
|
Search columns on multiple worksheets by
wally
In a workbook I have a worksheet for each month of the year. How would I be
able to automatically determine whether the entry currently being made has
been...
|
|
2 |
109 |
|
|
Moving data from row to columns by
gauche8715
I am trying to work with a dbase of names/addresses. The dbase is arranged
in a column with name, address, zip running vertically. I want to move the
info...
|
|
2 |
104 |