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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
How do I stop a general format from being autoformatted to date by cpp01rem
I want to stop Excel from automatically changing the format of a cell from general to time every time I enter a new row of data. I have several column...
November 21st, 2005 12:29 PM
by cpp01rem Go to last post
2 165
List box setup, placement, and functionality by Ladybug726
Hi - I created a template/form that will be used by 9 different individuals. The form will automatically generate a new Service Request number each time it is...
November 21st, 2005 03:52 AM
by Ladybug726 Go to last post
3 116
Insert Rows in Balance Sheet Template by Teacher_Becky
Using Excel 2002 I cannot find a way to insert/add additional rows to the existing 12 rows allotted in the Balance Sheet template. I learned from another...
November 21st, 2005 02:15 AM
by David McRitchie Go to last post
2 228
Record recording by cdixon
I need help in creating an automatic record form a file to an individual record. Example: You would make a work order for three different employees the first...
November 21st, 2005 01:23 AM
by Max Go to last post
2 191
Subject: Formula for by Adam Kroger
If you think your walls look bad, take a gander at mine. I am trying to create stable random number result.... Seems like it should be a simple thing to get...
November 20th, 2005 08:17 PM
by Ken Wright Go to last post
1 133
How do I get my formula to stay the same by BertiesMum
I have a worksheet to calculate 12 week averages, and every week I need to add a row, but my formulas automatically change so do not include the new row. What...
November 20th, 2005 04:00 PM
by BertiesMum Go to last post
4 100
More Formula Help Please by Andy JL
I already have this formula =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry")) I now wish to add if A1=D then B1=the word 'DAY' and C1= the word 'RATE'...
November 20th, 2005 01:16 PM
by Bernard Liengme Go to last post
2 165
FORMAT PERCENTAGE IN INDEX CELL? by Ladybug726
I have created a form in Excel - I want to use a Drop-Down or List Box for a salesperson to be able to select a multiplier (mark-up percentage) and have it...
November 20th, 2005 05:09 AM
by Anne Troy Go to last post
1 113
Calculate hour and minutes worked each day by Allan
As a novice to Excel I am trying to work out a formula to calculate hours and minutes worked each day (start and finish) and then at the end of the week add...
November 19th, 2005 10:32 PM
by David McRitchie Go to last post
3 170
How do I use a UDF? by Dorn
A udf was made for me and I'm positive that it works, however when I try to use it I get a "syntax error" and it highlights the first line of the code. I've...
November 19th, 2005 10:27 PM
by David McRitchie Go to last post
7 133
Numbering a Cell by Andy JL
Hi, I have created a Invoice in Excel from my Office 2000, and saved it as an Excel template, I have a invoice number in Cell E14 which is 16 at this time, I...
November 19th, 2005 02:41 PM
by Sandy Go to last post
5 125
Randomly Choose Cells from Colum/Row by J
hello. i'm not sure if this is possible, but i'm trying to randomly select multiple cells from a colum to be evaluated. for example, say i have a clumn of 10...
November 19th, 2005 02:22 AM
by Max Go to last post
2 149
last name, first name strings by data_diva
:confused: Hi there, I am a newbie and am having some trouble with seperating data in Excel. Here is my issue: I have a table of employee names are in one...
November 18th, 2005 10:39 PM
by Niek Otten Go to last post
6 242
sort alphanumeric data by yip
I have data with mix number of digits and I like to sort them. Somehow, the normal sorting process give me a not so desired result. Can anyone...
November 18th, 2005 10:31 PM
by Niek Otten Go to last post
2 143
create a hyperlink field for a tamplate? by NEWGUY
I have a template with various fields, when I make use of it, all fields are displayed correctly. One of this fields is a text string that holds pathname and...
November 18th, 2005 08:54 PM
by Gord Dibben Go to last post
1 117
confused on lotus by turkey
i've looked at other posts to my question and nothing works. can some one please help? --
November 18th, 2005 08:45 PM
by Barb Reinhardt Go to last post
1 116
opening lotus wk4 by turkey
i'm trying to open lotus .wk4 in excel and it gives me an error message. how can i open the lotus document in excel? --
November 18th, 2005 07:54 PM
by Anne Troy Go to last post
1 148
text string by TONY
I have a column in an excel sheet (max 65000 rows) which contains text. I want to strip off the first word of the text string and place this into a different...
November 18th, 2005 05:50 PM
by David McRitchie Go to last post
5 177
Cell Color Function? by DTTODGG
Hello - I'm wondering if there is anyway to control cell color based on a condition? If a cell is not empty - color = red If the date is older than last week...
(Multi-page thread 1 2)
November 18th, 2005 05:23 PM
by David McRitchie Go to last post
10 290
How do I sort data in excel by color? by Cyprus
Sorry, English isn’t my mother tongue, hope you’ll be able to understand my question anyway. I have a sheet with four columns of data. Three of them...
November 18th, 2005 04:47 PM
by Ron de Bruin Go to last post
3 184
Post New Thread


Display Options
Showing threads 10301 to 10320 of 13737
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 11:45 AM.


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