|
|
Reverse naming of file by
kenppy
Hi,
I'm copying data relating to an engineered part into a sheet.
The format is constant and the name of the client and part appear in
specified cells. Is...
|
|
2 |
196 |
|
|
|
March 5th, 2010 12:10 PM
by JLatham
|
0 |
229 |
|
|
|
March 5th, 2010 11:31 AM
by Lu
|
0 |
214 |
|
|
Insert Comments on a Protected Worksheet by
cinnie
hi - I have a worksheet with areas that are locked, and a range B5:H23 that
is not locked. Protection has been applied to the sheet. The user is
allowed...
|
|
1 |
213 |
|
|
Change format to mm dd yyyy hh mm ss by
Thomas
I am currently trying to convert my cells from this format 11/9/2009
08:26:21:523 to just mm dd yyyy hh mm ss, format. if anyone knows how to do
this, Your...
|
|
1 |
175 |
|
|
Database fields in Excel? by
James0007
I have an order sheet system set up in Word which uses merge fields in tables
to fill in store names, dates, etc. The "database" linked to the tables is
an...
|
|
0 |
168 |
|
|
Count with formatting by
mns
Hi,
I have used to styles which are pre-defined in office 2010 :) one of them is
greeny one named Good and yellowish one named Note.
I would like to count the...
|
March 4th, 2010 04:38 PM
by Eduardo
|
1 |
185 |
|
|
|
|
2 |
188 |
|
|
Formula by
remy5323
What is a formula?
|
|
2 |
256 |
|
|
Excel View by
iphoneaddict
When I am using Excel I can not see my fill colors in Normal View. I can hit
print preview and see the fill colors and the doc will print correctly,
however...
|
|
1 |
215 |
|
|
Workbook back up by
Aris
Hi,
Is there a way to have excel create a backup file saved somewhere each time
the workbook is either opened or closed? I know there is the auto recover but...
|
March 3rd, 2010 05:54 PM
by Aris
|
2 |
208 |
|
|
Count Cells with alphanumeric data by
Aris
Hi,
I'm just trying to count the cells in a range that have alphanumeric data.
example: asd, we, rty, 22r, 45aa, 1s, wer, tyu.
I need to count all cells...
|
|
8 |
191 |
|
|
|
March 3rd, 2010 05:30 PM
by george
|
0 |
186 |
|
|
get Cell to not display ( $ - ) by
Morgan
hi, i have cells that are formatted for accounting and the cell formula
contains the SUM feature, when the cells are empty and waiting for a value,
they...
|
|
3 |
216 |
|
|
|
|
0 |
206 |
|
|
Save as Template by
janey
I have a workbook which I would like to save as a template but can't find
how to do this in Excel 2007. Can anyone help, please?
|
|
2 |
208 |
|
|
Sort list by
janey
I have a table which I need to sort, e.g.:
2000
2039B
2026
2167
2239
2242
When I run Sort, I get
|
March 2nd, 2010 01:31 PM
by Max
|
2 |
285 |
|
|
SumIf Function by
jayceejay
I'm trying to use the SumIf Function (as I understand its use) and I keep
running into the same problems -- in many cases I have more than one
criterion for...
( 1 2)
|
March 2nd, 2010 08:11 AM
by sohail
|
10 |
456 |
|
|
|
|
2 |
212 |
|
|
incremental counting????? by
SBoers
I am workinging on an .xls spreadsheet with this numbering scheme in Column A.
1
1.1
1.1.1
1.1.1.1
1.1.1.2
1.1.1.3
1.1.1.4
1.1.1.5
1.1.1.6
|
March 1st, 2010 11:10 PM
by Max
|
2 |
211 |