|
|
Decimal/Percentage to Whole Number by
AAA1986
I have a column that is listed in decimals: e.g. .15, .30, .45. I would like
the column to be changed to whole numbers: 15, 30, 45. I was only able to...
|
May 28th, 2010 07:59 PM
by T
|
4 |
374 |
|
|
Parallel Box Plots by
Kristina
Hi,
I was wondering if it was possible to create parallel box plots on Excel
2007..
|
|
1 |
553 |
|
|
Can't drag new data to chart in 2007. by
roadkill
I have a series of charts that I update every 2 weeks with 2 more weeks of
data. When using Excel 2003 I was able to drag and drop the added 2 columns
of...
|
|
1 |
350 |
|
|
Zero's plotted in charts? by
Doug
Why would I show zero's for a column of data in my chart that are actually
very large(56869685). Some of my charts have date segments that are missing
when...
|
|
1 |
331 |
|
|
|
|
3 |
357 |
|
|
Text to Columns by
Emece
I have a column with the following data:
A
RUT 212874790014
Each cell has the word RUT, and the number changes, altough it always has 12
digits. I need to...
|
May 28th, 2010 06:45 PM
by Emece
|
3 |
360 |
|
|
|
|
1 |
312 |
|
|
|
|
4 |
533 |
|
|
Cannot get date to format correctly by
jknapp1005
I have a problem. I keep trying to format the date in certain cells, and it
keeps wanting to add the time. The date is pasted in from worksheets where I
had...
|
May 28th, 2010 05:40 PM
by DaveC
|
1 |
416 |
|
|
Excel 2010 not opening in maximized view by
racee
Hi,
I am starting to use Office 2010 and Excel is only opening in a small
window. Does anyone have knowledge on how to get it to open in full window
(be...
|
May 28th, 2010 05:39 PM
by racee
|
1 |
774 |
|
|
Date changes in data by
myasmana
I have a spreadsheet that has a date column which is required. The
spreadsheet is then uploaded for a conversion into another software product
we use. This...
|
|
1 |
370 |
|
|
Lookup based on matrix values by
andy62
I am struggling to develop one of those "copy down" functions that can
produce a set of values. In this simplified example, the formula needs to
tell me the...
|
|
2 |
344 |
|
|
Can I calculate a single page ONLY? by
dh13134
Can I calculate a single sheet only, and disable calculation update on other
sheets? I have several sheets that take a few seconds (too long, in my case)
to...
|
|
1 |
322 |
|
|
|
|
3 |
431 |
|
|
Pivot Table Field Settings by
ScottyR10
I have a table where one column of my data that I am counting will have Zero
or Null Values in some rows. How do I exlcude those rows, so the data shows
mee...
|
|
0 |
299 |
|
|
A single Page print for key items by
jeffkeef
I have a 2900 line spreadsheet from top to bottom with information about
rooms and organized by it's room number:
example:
col a: b : c : d:
101: Main...
|
May 28th, 2010 03:34 PM
by steve
|
1 |
330 |
|
|
Consolidating Data by
Steve
I am creating a checklist type data base for construction refurbishing.
We have a list of all items we will do for different rooms, exteriors and so
on.
If...
|
May 28th, 2010 03:14 PM
by tim m
|
1 |
303 |
|
|
data - validation - list question by
rwbaker
excel 2003
I have several cells that I have some custom data validation configured
I also want to have a in-cell drop down list for these cells
Can some...
|
|
2 |
390 |
|
|
text combined with values by
gloucester county
In cell A1 I typed s1.5 in cell A2 I typed s2 how do I add the values to
equal s3.5?
|
May 28th, 2010 03:09 PM
by tim m
|
3 |
321 |
|
|
Enlarging Command Buttons by
RussellT
I have a number of Command Buttons embedded on Worksheets. For some reason
some of them tend to grow in size upon usage to the point that after a while
they...
|
|
2 |
301 |