General Discussion - Page 201 - 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.

Thread / Thread Starter	Last Post	Replies	Views
Return Blank instead of Zero by Db1712 I have two cells linked, is there a formatting to return a blank instead of zero when the cell its linked to is...	February 27th, 2005 04:37 AM by Ragdyer	9	110
Lookup Function Problem by seve I am using lookup function properly (I think). Problem: If the lookup value is in the lookup vector no problem. But if the lookup value is not in the lookup...	February 28th, 2005 02:46 AM by Ragdyer	9	369
change nonworking day to friday by salim purayil how can i change nonworking date from saturday&sunday to frinday&Saturday	March 1st, 2005 10:22 PM by Myrna Larson	9	226
Pivot Table - Calculated Field by fnov Would appreciate assistance with Calculated Fields in a Pivot table. I would like to perform a calculation which invovles a reference to the total of a field...	March 6th, 2005 06:19 PM by Debra Dalgleish	9	270
sum question by sanj I have 20 tabs in my excel file.I need to check sum of numbers in cell A14 for all 20 tabs.Instead of going to each tab and adding A14 cell for each tab , is...	March 15th, 2005 11:41 PM by JulieD	9	119
return last values by Rob_B Hi, I have a bowling spreadsheet that I list as: Date Game1score Game2score I want to be able to use a weighted average by averaging all scores, but...	March 8th, 2005 06:45 PM by Sandy Mann	9	94
Pop Up Message by AK Based on the entry in a cell in a column (B), how would a message box appear based on the entry. Example: If B2 = "NY", message box would appear, "Talk to...	March 12th, 2005 07:28 PM by Earl Kiosterud	9	115
Cntrl find - cannot locate zip codes that start with zero. Possibl by jjjJackieCalifornia I have a large excel worksheet - zip codes, cities, states, area codes ... I need to be able to sort as well as find. Problem comes in with states that have...	March 12th, 2005 08:27 PM by jjjJackieCalifornia	9	161
Data Validation by Daniel Bonallack I'm encountering a frustrating problem relating to data validation, and I'm sure there's a simple answer. On one sheet only, when I set up Data Validation...	March 17th, 2005 11:52 PM by Max	9	99
How do I get brackets around negative numbers? by Gordon Valtam wrote: My regional setting in Windows XP Home shows negative number format to be in brackets yet the number format in Excel 2003 still does not ...	February 27th, 2005 11:53 PM by Gord Dibben	9	188
How to preserve conditional formatting on a web query table result by Simon L I have an external database that Excel queries and returns two columns of dates. I can set up a conditional format (in one colum) so that the dates in each...	February 26th, 2005 01:19 AM by Arun	9	122
Computer freezes while using mouse to select group of data in Exce by mfshook62 Regularly, when mousing to select a group of data in a column , using Excel, the computer completely freezes up, and I have to hard reset to recover. This...	March 7th, 2005 08:27 PM by Manish	9	150
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. by RonMc5 I use a workbook with 53 sheet to keep track of mileage info for expenses. There are two references to the previous sheet. EG: Current sheet is sheet5! I need...	February 3rd, 2005 12:51 AM by Harlan Grove	9	510
How do you install help for excel 4.0 macros in Office 2003? by Macliam The download center says to download Excel 2000 Help File: Running Excel 4.0 Macros, but when I try to runit it says that no Windows 2000 installation...	February 4th, 2005 03:08 AM by Myrna Larson	9	404
Excel 2003 / Windows XP Pulsating Excel screen !! by monir How do I suppress jiggling / pulsating Excel screen, mouse pointer, task bar Ready, etc. ??	February 7th, 2005 10:50 PM by Dave Peterson	9	563
limit number of characters in a cell by abfabrob I am creating an application form to be used electronically. I want a particular cell to be free text, so users can write what they like (ie their name), but I...	February 11th, 2005 04:19 PM by L. Howard Kittle	9	202
Can I show server name instead of drive letter? by bfant When using the =Cell("filename") function, I would like to show the actual server instead of a drive letter because the letter is dependent on where the server...	February 17th, 2005 06:11 AM by bfant	9	211
import multiple workbooks into 1 workbook by Anita I'm setting up a webshop and using Excel to put in the products. I've got seperate workbooks for my 20 product-groups (20 excel documents), and each group is...	February 18th, 2005 04:05 PM by Ron de Bruin	9	232
2 DIGITS OUT OF 4 by gregork From a four digit number I want to have a formula that extracts only the middle two numbers eg." 5062" would equal "06" or "4113" would equal "11". GK	February 20th, 2005 03:30 PM by Jack Sons	9	134
Working with Excel by Igor2005 Dear friends! I have the following problem - I am needing to represent in Excel a number with 20 (or more) digits. How can I do this? Many thanks!	March 22nd, 2005 08:36 AM by Jan Karel Pieterse	9	106

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed