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
/P Startup Switch in Excel 2000 by Joe
I'm trying to use the startup switches in Excel 2000 to do the following: Open a spreadsheet as read only, and set the "save" path to a different...
July 22nd, 2004 05:22 PM
by Jim Rech Go to last post
1 457
Locked for Editing problem -- Solved by dh
There have been many posts in this forum regarding problems with Excel reporting "Locked for Editing" when, in fact, the file is not in use by anyone else....
July 22nd, 2004 05:05 PM
by dh Go to last post
0 208
Date Calculations by simoncohen
Cell A1 contains accounting Period start Date say 1/2/04 A2 contains accounting period end date say 31/1/5. A3 contains a different start date say 1/4/04 and...
July 22nd, 2004 03:45 PM
by acedia Go to last post
3 297
Extracting Email Addresses by Jumbo
Hello all, I need some help on how to extract email addresses from a worksheet that contain cells with either text or an email address. The problem is...
July 22nd, 2004 03:23 PM
by Ron de Bruin Go to last post
3 226
MS Query - Parameter Bug by TedGrier
I have an Excel 2002 worksheet connected to a SQL Server 2000 database. The data query is simply: SELECT Count(*) FROM Orders WHERE SALE_DATE= When prompted...
July 22nd, 2004 03:23 PM
by TedGrier Go to last post
2 220
Comparing Text in adjacent columns by ADArnold
Good Morning Group, I am a Commercial Real Estate Broker and I have several databases with building tenant and owner information that I need to make mailing...
July 22nd, 2004 02:46 PM
by ADArnold Go to last post
6 377
Creating a pivot table for text data by Kelly
Is there any way to create a pivot table for data containing alpha characters? I need to create a cross reference table for a 3 column list of data with...
July 22nd, 2004 02:41 PM
by Kelly Go to last post
2 368
Keeping text formatting when referencing a text cell by Posty
When referencing a text field in another column, the formatting of the content does not get copied over. Example: A1 (Text) This is formatted text data A2 ...
July 22nd, 2004 02:39 PM
by Posty Go to last post
4 716
saving in sequential numbering i.e 1,2 3 etc or by date/time? by stevehorton
Hi there, Currently i have a vb statement that will copy a sheet and then save it to a certain location. what im interested to do is to set it up so when i...
July 22nd, 2004 02:36 PM
by Rollin_Again Go to last post
2 150
mph in excel by rawclark
Does anyone know of a formula for calculating time from speed and distance? As in d=3 miles; s=45mph; t=00:04 (hh:mm). There must be a standard formula for s....
(Multi-page thread 1 2)
July 22nd, 2004 02:27 PM
by rawclark Go to last post
14 248
merge or combine columns by Lee Beck
Is there a way to combine columns? I have a spreadsheet with a couple thousand rows. I want to give each row a unique identifier that has the components of a...
July 22nd, 2004 01:44 PM
by Go to last post
5 339
Complex Network Days function & Time - Help please by Adam
Morning All, I am attempting to work out the time in which a customer enquiries been open for. I have the below info: A5 Call date B5 Call Time I5 Todays...
July 22nd, 2004 01:09 PM
by Jerry W. Lewis Go to last post
1 156
Excel Opens 2 files, I only created one? by Andy Wiggins
You get these by clicking on: Window New Window To get rid of excess windows, click on "Close Window" (that's the cross in the top-right of the screen...
July 22nd, 2004 11:44 AM
by emea training 2 Go to last post
1 401
scrub file before submitting by goss
Hi ng Using xl 2003 Need to scrub a text file before submitting Desired output: Inv # || Inv Amnt || Date || FAS? || FAS# Problem:
July 22nd, 2004 06:38 AM
by Biff Go to last post
4 196
Excel Worksheet Formula Question by TCIDawn
I know there is a simple formula for this, but I haven't had to work with this for so long, I just can't seem to pull it from my memory, and I don't know the...
July 22nd, 2004 06:19 AM
by Frank Kabel Go to last post
3 399
copy data validations from 2000 to 2003 by A0
Hello, Is there any known problem with copying cells with data validation (list) from excel 2000 workbook to excel 2003 workbook ? Copy / Paste - paste the...
July 22nd, 2004 05:34 AM
by A0 Go to last post
6 221
fractional pennies by gary
28,000 cells are SUPPOSED to be rounded to 2 decimal places. However, their total is: 28,0004,231,983.34000001000. How do I find the cells containing these...
July 22nd, 2004 03:46 AM
by Jerry W. Lewis Go to last post
7 151
Piviot Tables by 0013
I have the following...
July 22nd, 2004 03:41 AM
by Debra Dalgleish Go to last post
1 135
after hitting enter by Don
When you hit the ENTER button.. the cursor will move either right,left,up or down... Is there a way to have it move to specific cell for example if your add...
July 22nd, 2004 03:06 AM
by Ragdyer Go to last post
2 196
Make all number values BOLD that meet criteria ? by brazen234
Frank Kabel wrote: Hi for formating prime numbers try the following: 1. Insert the following user defined function in one of your modules (function...
July 22nd, 2004 02:54 AM
by Dave Peterson Go to last post
3 344
Post New Thread


Display Options
Showing threads 137941 to 137960 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 12:51 PM.


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