|
|
How to set the default format on excel? by
Eric
Does anyone have any suggestions on how to set the default format on excel
2003? such as font, size, center align, whenever I open, it is all set.
Thanks in...
|
|
3 |
1,092 |
|
|
Consolidating data by
BDT
Hi,
I need to consolidate some lines of data in a 19K line spreadsheet and then
change its basic format.
I have 3 columns of data: ID# | date |...
|
|
1 |
917 |
|
|
Separate AM/PM from time. by
cuartetto
In column B I have 1000 time entries with the following format. 9:30AM,
10:30PM. I would like to move the AM or Pm into a new column. I've tried
"fixed...
|
|
2 |
999 |
|
|
Macro/VB coding question by
melExcel2007
I want a macro to work for a worksheet name which will always be the same
directory and file name but the data inside worksheet will periodically
change -...
|
|
3 |
991 |
|
|
Set row height, but allow wrap text by
KMM
I want to set the row height of me spreadsheet to allow a little "buffer"
between rows. But I have a couple rows in which there is a greater amount of
data...
|
June 4th, 2010 11:01 PM
by KMM
|
0 |
955 |
|
|
SUMIFS by
RAK
My SUMIFS formula was "accepted" but the result is 0.0 even though there are
numbers to add. What can the problem be?
The formula is...
( 1 2)
|
|
10 |
1,484 |
|
|
|
|
1 |
1,029 |
|
|
Printing in Color by
Fill Colour for Different data
Ever since my printer has been networked by the cells in my excel if filled
with color do not print in color. The print preview displays the various
colors...
|
|
0 |
923 |
|
|
Pull value from another sheet by
laughlinl
I have multiple sheets in my workbook. On the first sheet, I am pulling data
from all the other sheets for a comparison. I need to pull in a commission
level...
|
|
2 |
994 |
|
|
Macro to affect all sheets by
REMB
I want to select all sheets in a workbook, insert a column, and put a formula
in that column. It works fine when doing it manually, but if I try to have a...
|
|
3 |
877 |
|
|
|
|
1 |
811 |
|
|
data conversion by
Candida
Please advise how I can convert a number that comes over as '40593 from our
Italian firm. How do I take the ' off of the number. I have 3000 rows of
numbers...
( 1 2)
|
|
11 |
1,301 |
|
|
Sumproduct;3 criteria by
GregL
Hello,
I need a formula that will sum the dollar value of a column if the entries
meet 3 seperate criteria.
The current formula I have (that returns a #NUM...
|
|
5 |
1,364 |
|
|
|
|
1 |
1,008 |
|
|
|
|
1 |
953 |
|
|
|
|
2 |
1,100 |
|
|
|
June 4th, 2010 08:13 PM
by Vicki
|
2 |
1,040 |
|
|
Text Parsing with uneven lengths by
dks345
I have cells that contain data such as:
General Motors 22779
United States of America 1449
Carlsbad 712
Under 21 Children 12
I would like to parse the...
|
|
2 |
992 |
|
|
Pivot Table by
KTR
I have a pivot table based on an excel worksheet with five columns - Date,
Call From (Names), To, Time, and Type.
In the pivot table, i am using From for the...
|
|
1 |
990 |
|
|
|
June 4th, 2010 07:25 PM
by John
|
2 |
968 |