|
|
How to unhide column? by
Lois Corp Secy
I hid column E, did some other work on the spreadsheet, now cannot unhide
column E
|
|
2 |
165 |
|
|
Creating backgroound for an Invoice by
Gary
I am creating an invoice using Excel. The invoice has already been
created and is fine. I am now just trying to input a header and footer
with a middle. I...
|
|
1 |
196 |
|
|
|
|
2 |
186 |
|
|
PLEASE HELP by
sagenichole
Ok I am trying to make the document where if I enter "a" in one cell, the
cell next to it will auto populate a given value that I define. Please let me
know...
|
|
3 |
184 |
|
|
Time formula by
Dottie
Working with a spreadsheet (Excel 2007) that has a start time, end time and
time
Start Stop time
14:00 15:18 1:18
Would like to convert time to minutes and...
|
|
5 |
126 |
|
|
Convert a text in a date format by
xBeckx
Hi
I have imported a file where there is a field that is suposed to contain a
date. It was transformed in text, like 22FEB2010. I need to treat this field
as...
|
|
2 |
168 |
|
|
|
|
1 |
308 |
|
|
Find the last number in a row by
David Brogelli
Hi,
I have lots of rows of data which are either a value between 50 and 200 (e.g
115) or "0".
Each column is a specific week of the year, ie from 1/1998 to...
|
|
5 |
204 |
|
|
Combine data into central worksheet by
Candida
I have a main costing work sheet that needs to be populated by individual
costing sheets that went out to all of the buyers to populate.
Main Costing...
|
|
1 |
139 |
|
|
Separate Date from a Text String by
Sara
The data that I have looks like this:
And I would like to just get the date like this:
10/24/10
Is there any way to do this in Excel with a...
|
May 18th, 2010 03:41 PM
by Sara
|
3 |
174 |
|
|
Formulas by
Raja
I wanted to enter a number in a cell for example 10 in A2 and this number
should be converted into a letter say "A"in A2 cell. How could it be done?
|
|
2 |
152 |
|
|
|
|
2 |
142 |
|
|
Define a Value by
sagenichole
Thank you to those who posted to my question earlier, but just to give a
little more insight on what I am trying to do:
I have a scroll list in one cell and I...
|
|
2 |
144 |
|
|
|
|
1 |
222 |
|
|
Copying "Exact" Function by
Nats_uk
I have an excel spreadsheet with two columns, legal forename and preferred
forename. I ran a "exact" function so it would appear true if the two
surnames...
|
|
2 |
132 |
|
|
Repeat Sort in Excel 2007 by
Kevin K[_2_]
In Excel 2003 you can repeat sort parameters for different sections of a
worksheet by using the F4 function key after performing your 1st sort, but I
can't...
|
|
4 |
201 |
|
|
Formula to get date from text string by
Sara
This is what the cell currently looks like:
I would like the formula to return only: 10/01/09
Does anyone know what formula I should use? Any help would be...
|
|
2 |
168 |
|
|
|
|
0 |
124 |
|
|
|
|
2 |
161 |
|
|
Sum Formula dilemma - Can yu Solve? by
Tom
Have a column for item id and a column for its Qty. What I need to do is have
a sum of all the item id quanitities whose item id is either a 1, a 3, or a
7....
|
|
3 |
188 |