A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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 Go to last post
4 181
Parallel Box Plots by Kristina
Hi, I was wondering if it was possible to create parallel box plots on Excel 2007..
May 28th, 2010 07:18 PM
by Jon Peltier[_2_] Go to last post
1 290
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...
May 28th, 2010 07:16 PM
by Jon Peltier[_2_] Go to last post
1 179
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...
May 28th, 2010 07:14 PM
by Jon Peltier[_2_] Go to last post
1 118
conditional formatting for more than 3 conditions by Jai
Hi, Is there any solution for the following : I have six type of conditions, if any condition is met, cell colour should be yellow. For example, if cell...
May 28th, 2010 06:59 PM
by Don Guillett[_2_] Go to last post
3 197
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 Go to last post
3 181
How do i hide carriage returns? by TVGuy29
How do i hide carriage returns? (the "boxes" behind a line of text)
May 28th, 2010 05:55 PM
by Gord Dibben Go to last post
1 147
Trace links between worksheets within one workbook by Bean Counter[_3_]
Hi Gurus!! I have a workbook that contains about 20 worksheets. Some of these worksheets are operations files from other departments, but others are a...
May 28th, 2010 05:43 PM
by Bean Counter[_3_] Go to last post
4 305
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 Go to last post
1 235
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 Go to last post
1 579
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...
May 28th, 2010 04:57 PM
by Gord Dibben Go to last post
1 216
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...
May 28th, 2010 04:54 PM
by BSc Chem Eng Rick Go to last post
2 190
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...
May 28th, 2010 03:53 PM
by Tom Hutchins Go to last post
1 140
Argument description by steve
What does =+SUMIF($G10:$G31,"Yes",I10:I31) mean? -- steve
May 28th, 2010 03:50 PM
by bala_vb[_29_] Go to last post
3 192
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...
May 28th, 2010 03:41 PM
by ScottyR10 Go to last post
0 160
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 Go to last post
1 176
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 Go to last post
1 154
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...
May 28th, 2010 03:13 PM
by Gord Dibben Go to last post
2 233
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 Go to last post
3 170
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...
May 28th, 2010 03:06 PM
by Don Guillett[_2_] Go to last post
2 161
Post New Thread

Display Options
Showing threads 321 to 340 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.