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
Anyone familair with Documentum Webtop and running Excel macros? by paankadu
The company I work for uses Documentum Webtop as its document storage base. I have created daily logs to be used for various job areas. Outside of...
November 18th, 2009 05:32 PM
by paankadu Go to last post
0 80
Way to keep formulas unchanged when deleting rows? by PeteJ
I have a bunch of references to some data that I copy into a datasheet. Occasionally, this data has some blank rows or rows with unneeded data in it. If I...
November 18th, 2009 05:19 PM
by PeteJ Go to last post
8 100
Paste as text not HTML by RealGomer
In WOrd 2007 one can FINALLY paste info from a web page as text as the default, not as HTML. Is this available in Excel 2007? I can't find it. -- Für Elise...
November 18th, 2009 04:55 PM
by RealGomer Go to last post
0 91
Change cell colours using hyperlinks by Lynda
I have hyperlinks going from sheet 1 to descriptions in sheet 2. What I want to happen is when I click on the hyperlink in sheet 1 that it will highlight the...
November 18th, 2009 04:12 PM
by Marswii Go to last post
9 94
Rounding up or down to nearest whole number by KC
What formula would I use to round a number to a whole number, ie 2.4 would round to 2, 2.55 would round to 3. I'm tried using the following formula, however...
November 18th, 2009 04:08 PM
by Tom Hutchins Go to last post
1 91
MS Excel 2003 Window by NFL
Is there a way I can have the worksheet hover over the menu bar so I can maximize the window space I need when working on several files? Thank you
November 18th, 2009 04:06 PM
by Bob I Go to last post
3 78
Microsoft Office Word 2007 Vista comes up with a message by Alex V
"Preparing to install" and then "wait while Windows configures Microsoft Office" How do I get it to open immediately without this initializing each time?
November 18th, 2009 04:04 PM
by David Biddulph Go to last post
1 104
barcode in excel by Nik
I need help to convert cell with 13 digits to bar-code (code128). I'm not very good in programing so I have to find alternative way (if there is one) Thx in...
November 18th, 2009 04:02 PM
by Bob I Go to last post
2 87
Shewhart and Westgard rule? by Hansyab
How do I prepare a Shewhart Chart and What is the Westgard Rule? Thanks for your help.
November 18th, 2009 03:59 PM
by Barb Reinhardt Go to last post
2 117
EXCEL 2007 - DATA VALIDATION LIST by Asoka Walpitagama - Brandix College IT
To have a short list feature in DATA VALIDATION LIST like in Oracle forms LOV( List of Values ) Can include an option " Sort the list & allow short listing"...
November 18th, 2009 03:28 PM
by Bob I Go to last post
1 77
EXCEL WORK BOOK DUPLICATES WHEN OPENED by Asoka Walpitagama - Brandix College IT
An Excel work sheet that I received, opens 5 copies when I double click to open ( NOT WORK SHEETS ) It opens the same workbook 5 times. How to avoid this ?
November 18th, 2009 03:25 PM
by Bob I Go to last post
1 74
EXCEL 2007 -INSERT WORK SHEET ICON by Asoka Walpitagama - Brandix College IT
When the number of sheets increases, the INSERT WORK SHEET ICON is not displayed. Why not you keep it visible always. ---------------- This post is a...
November 18th, 2009 03:24 PM
by Bob I Go to last post
1 84
Cell showing date and time - precision error by simonc
I have a cell set up as format dd/mm/yyyy hh:mm:ss and the contents are 01/01/1995 00:00:00 In the cell below I put 01/01/1995 01:00:00 then fill the cells...
November 18th, 2009 03:04 PM
by Gary''s Student Go to last post
2 88
Pivot Table criteria by Mouimet
I'm runnung Excel 2003 I create a Pivot table to see sales, refused and Pending if days is than 45 In my data table I have a column showing 2,3,4, 40, 45,...
November 18th, 2009 02:52 PM
by Mouimet Go to last post
2 78
number setting for workbook e.g. i want , instead of . in number by Rajesh
I want my excel should display number in US format not i German format. How to change number display setting for whole excel file.
November 18th, 2009 02:32 PM
by Jacob Skaria Go to last post
1 85
Compare two dates by Dave
Hi,. I would like to compare two dates in the same row and return a true or false statement. How do I do this?
November 18th, 2009 01:41 PM
by Dave Go to last post
3 95
Interpolating value by willemeulen
When a chart generated is it possible in exel to return a value from the chart or chart data by reading chart or interpollating value from knowns....
November 18th, 2009 12:50 PM
by David Biddulph Go to last post
1 91
Help With My Excel Database by Roopesh1978
The following is what I need help with: (1) I have a main sheet where I am entering my data. I have defined a dynamic range for this data so that if I...
November 18th, 2009 12:34 PM
by Roopesh1978 Go to last post
2 73
External link update macro by Ashley
I am trying to write a macro that will open all sources of external links to my document, save the document & then close all sources again. I have been able...
November 18th, 2009 11:39 AM
by Gary''s Student Go to last post
1 107
Year/Month/Date Question by Mike
Is there a formula that can calculate years, months and days into a decimal? For example: 23 years, 6 months, 0 days would be 23.5 years.
November 18th, 2009 11:34 AM
by David Biddulph Go to last post
4 115
Post New Thread


Display Options
Showing threads 9841 to 9860 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 05:16 AM.


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