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
cell format by Jean
Could I get the correct way to format cells in Excel 97 SR2 to include text and numbers? For example, I need the string L1234567891 to show as L-123-456-7891....
June 15th, 2004 11:42 PM
by Jean Go to last post
2 162
Maximize setting when opeing excel by rollingdan
When I open my Excel program my spreadsheet is always less than minimized. Very annoying as I always have to maximize before doing anything. I tried...
June 15th, 2004 11:23 PM
by rollingdan Go to last post
7 251
Formatting to Currency does not get applied by
I have a column of numbers formatted without dollar signs & decimal points: 1234 5678 9100 I want to apply Currency formatting with decimal points. I select...
June 15th, 2004 11:17 PM
by Gord Dibben Go to last post
5 279
need to fix file title in macro by leeners82
I have the following macro created which allows the user select a file from which a worksheet is copied in to the 'report' sheet of the macro-containing file. ...
June 15th, 2004 11:02 PM
by Anders Silven Go to last post
1 170
Overlapping time ranges by jsollman
I am trying to create a formula to show the total time a factory line was down during a given shift. my problem is the overlapping times. If i just sum the...
June 15th, 2004 10:46 PM
by Anders Silven Go to last post
2 183
Formatting Cell Text by Ben
Can you set a text up to display number's in foot and inches example 12 would appear as 1' 13 would appear as 1'1' etc.? Thanks, Ben
June 15th, 2004 10:28 PM
by Ben Go to last post
2 98
naming sheets by James
hi guys! is there a way to rename multiple sheets in a workbook at the same time, keeping them in sequential order? for example instead of sheet 1. sheet...
June 15th, 2004 09:25 PM
by James Go to last post
3 215
Mail by Sashi
I had used the "E-Mail" button to mail a workbook. Since then , whenever I open that workbook, the Outlook Express log-in window pops up. How do I stop...
June 15th, 2004 09:10 PM
by Go to last post
2 203
Opening multiple windows of same workbook with macro by surveyorinva
I created a macro that will open several windows of the workbook I have created and each window will show a different tab on a different place on the screen. ...
June 15th, 2004 09:00 PM
by Jim Rech Go to last post
1 250
Need Help on IF statements by JMyers
I am trying to create an xls template. I have it where in like B27, the user enters a numeric varialble. once that variable is entered, in D27 it will...
June 15th, 2004 08:55 PM
by Ron Rosenfeld Go to last post
2 171
Function needed! by dwboiler
I need a function that will search a column of dates and count the number of occurances in each month so I can graph the number of records by month. My first...
June 15th, 2004 08:43 PM
by Ron Rosenfeld Go to last post
2 231
Create hyperlinks using VLOOKUP? by lunker55
I would like to enter a model number(CM3636a) in A1. When entered, is there a way to lookup in a table and create a hyperlink automatically? I have hundreds of...
June 15th, 2004 08:36 PM
by lunker55 Go to last post
4 241
Hide selective sheets "veryhidden" by Jonsson
Hi, I have record this code to get certain sheets hidden. The WB contains a lot of sheets and I only want to hide some of them. The code works great as long...
June 15th, 2004 08:29 PM
by Jonsson Go to last post
5 252
Left Justify in a Custom Footer by Dave Y
Hello, I need to add a legend for a spreadsheet as a Custom Footer in the center section of the Footer dialog box. Is there a way to left justify the text...
June 15th, 2004 08:28 PM
by Dave Y Go to last post
2 224
How can I check 2 cells? by Aversin
How can i check Cells D1 and C2 to see if there is a anything written in them? (notes) I would like to check D1 first, and if it is empty check c2, and...
June 15th, 2004 08:25 PM
by Frank Kabel Go to last post
1 79
array data type by anjem
Hi, I'm trying to take a column of integers and input them into an array which I can then use for a loop instead of using this format: If...
June 15th, 2004 07:56 PM
by Alan Beban Go to last post
3 170
Excel - Imported Number to Phone Number by benallred99
Is there a way to change an imported number such as: 7042626598 and display it as a phone number like: (704) 262-6598 ? Thank you,
June 15th, 2004 07:52 PM
by Kevin K. Go to last post
2 319
Conditional Formats by AlfD
Hi! A simple thought: you seem to be interested if the biggest value occurring in your list is 100%. If so, set your flag to show if max(A1:A200)=100%....
June 15th, 2004 07:48 PM
by Et3rnal Go to last post
3 172
Formula for returning a yes or no answer by Bonny
Can anyone tell me what the formula is for returning a answer of yes or no, i.e. you have a list of cars and you want to mark all the ford cars with a yes and...
June 15th, 2004 07:48 PM
by Paul B Go to last post
1 196
linking drop down menu items to corresponding items in other lists by Jklay
My original task was to take two columns with 6 items in each and collapse them - where the first item of the first column somehow links to the first item of...
June 15th, 2004 07:42 PM
by hglamy Go to last post
2 387
Post New Thread


Display Options
Showing threads 139561 to 139580 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:25 PM.


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