|
|
converting date to text by
SallyP
Hi ,
I would like to convert my date which is formatted as mm/dd/yy to a text
format but i dont want to change the way the date looks. Currently every time
i...
|
|
2 |
185 |
|
|
Cell fill color changes by itself by
A.O.
I have a user who has excel worksheets that they use fill colors. These are
colors that they use all the time. Suddenly when she opens the sheets, the...
|
April 14th, 2010 11:54 PM
by A.O.
|
0 |
104 |
|
|
|
|
5 |
146 |
|
|
SUMIF w/multiple conditions by
lightstation67
Here's my current formula:
=SUMIF(A3:A50,"Consumer",J3:J50)/C55
This works fine to get an average sum for everything that reads Consumer,
but now I need to...
|
|
5 |
151 |
|
|
|
|
2 |
183 |
|
|
|
|
1 |
194 |
|
|
Cell Border Symbols by
Jim
All,
My question is surrounding creating a calendar in Excel. I'm wondering if
there is a way to change the shape of the cells so that I can call attention...
|
|
1 |
113 |
|
|
Footer date format by
Rita Brasher[_2_]
Office 2007
I have inserted the date in the footer. The date format is 04/14/2010.
I want to change the format to April 14, 2010. Where can I change the...
|
|
2 |
136 |
|
|
Need help formatting rows by
bobby02169
Hello everyone,
I am using excel 2007
I would like to know how to do the following if possible
have column A add column B and put the total in column C and...
|
|
2 |
128 |
|
|
|
|
1 |
129 |
|
|
Protecting sheets with drop down boxes by
Dolores Gomez[_2_]
I have an excel spreadsheet that has drop down boxes and formulas. I want to
be able to protect this spreadsheet so that other user will not delete my...
|
|
6 |
154 |
|
|
Entering and displaying time by
jdj420
I want to know if there is a way to enter the value of a cell as (for
example) 2330 and it display as 23:30?
|
|
1 |
176 |
|
|
Duplicate data by
Jodi
I have a file that contains duplicate supplier records and I want to be able
to identify where a supplier number is duplicated and then delete all but 1
of...
|
April 14th, 2010 09:31 PM
by sq
|
2 |
82 |
|
|
|
April 14th, 2010 09:20 PM
by Tonso
|
1 |
143 |
|
|
|
|
2 |
102 |
|
|
|
|
1 |
122 |
|
|
Using an If statement by
kmt1984
I have been searching the discussion boards and haven't found the answer to
my question.
Basically, if B7, B13 B42, B44, etc. have anything entered I would...
|
|
3 |
97 |
|
|
Disable Options in 2003 by
Jeremy
I am wanting to disable to 2003 options to where a user can not turn on the
row & column headers.
Can someone please help with this.
Thank you
|
April 14th, 2010 07:36 PM
by FSt1
|
1 |
123 |
|
|
|
April 14th, 2010 07:20 PM
by JLatham
|
1 |
149 |
|
|
Excel calcutions using date/timestamps by
ghl
I'm trying to write an excel formula to calculate the performance improvement
using timestamps.
Process A took 2hrs, 20 min, 9 sec expressed as ...
|
|
1 |
122 |