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 : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
changing the pagebreak by marilyn
I am unable to change the pagebreak on any spreadsheets and the fit to one page is not set. Is there another setting that could be preventing me from changing...
February 10th, 2004 09:53 PM
by Jonathan Rynd Go to last post
1 85
Changing values by Becca
We are in the process of changing our accounting software. I have two columns, one with the old account number and one with the new, corresponding number. ...
February 10th, 2004 09:58 PM
by Becca Go to last post
2 268
Auto input? by Crystal
From: Crystal Subject: Auto input in different columns Date: Tuesday, February 10, 2004 4:07 PM I have a workbook that I input customer...
February 10th, 2004 10:10 PM
by Crystal Go to last post
0 247
conditional formatting by Jon Barchenger[MS]
Good morning Jamie - Sounds like you want to change the Number Format of a cell based on a value in a cell, using Conditional Formatting. Sorry you only can...
February 10th, 2004 10:38 PM
by angela Go to last post
3 262
Calculate cooking time by Pierre
This one's got me: Trying to calculate "begin cooking" time based on length of a foods cooking time until done, and desired done time. IOW. . . Need a...
February 10th, 2004 10:43 PM
by Pierre Go to last post
3 486
Ye olde blank cell question.. maybe by XLguy
I assume this question has been asked a dozen times but *I* haven't quite seen it asked yet. I have seen similar questions but they are not the same.. at...
February 10th, 2004 10:49 PM
by XLguy Go to last post
3 476
Daily To Weekly Formulations Down Columns by Vanguard
I have a spreadsheet that has daily values in one column with data in the second. On another tab, I have weekly rollup data to give me a sum or average of a...
February 10th, 2004 10:56 PM
by Frank Kabel Go to last post
1 166
Excluding a cell from the print area by Tim Richards
I need to exclude a cell from printing on my report. This cell happens to be in the center of my worksheet. I want the cell to be displayed on-screen, but not...
February 11th, 2004 12:26 AM
by Tim Richards Go to last post
2 169
Amortizing Term on a loan by Rachel
How do I figure the amortizing term on a loan? =ABS(NPER(+K8*0.01/12,-(J8),,-O8)) This is currently the formula that is showing. This is a spreadsheet that...
February 11th, 2004 12:43 AM
by Fred Smith Go to last post
1 79
A way to not refresh data on screen? by Kenji
When I run the macro, the Excel sheet does a bunch of activities. Is there a way to disable refreshing the screen.. so the user doesn't have to see all the...
February 11th, 2004 02:45 AM
by Kenji Go to last post
3 115
Need help with adjusting width of VBA-created toolbars by Mark Reynolds
Hello, I am using VBA to create a series of toolbars, which are then assigned to macros. The problem I am having is: If I create a toolbar manually, it...
February 11th, 2004 03:24 AM
by Mark Reynolds Go to last post
2 131
Question: About using COUNTIF in a filtered list by acw
Scott Send a copy of the workbook to . I'll have a look. Tony ----- Scott wrote: ----- Tony,
February 11th, 2004 03:32 AM
by Debra Dalgleish Go to last post
1 402
Excel worksheet - transferring totals to new worksheet by Lisa Glase
I've created a worksheet that has some data and a total column for the month of January. I would now like to use that same sheet for February, clearing out...
February 11th, 2004 03:34 AM
by Peter Atherton Go to last post
2 327
Auto size row by mgolden
I can't seem to merge cells and wrap text and have the row automatically size itself to fit the data. If you wrap text in a single cell it works, does...
February 11th, 2004 07:38 AM
by Gord Dibben Go to last post
2 235
Removing blank characters in a cell by Roger Govier
Hi Goonly Try =SUBSTITUTE(SUBSTITUTE(A1,CHAR(12),""),CHAR(160),"")*1 to remove both spaces and / or the non-breaking space CHAR(160) which sometimes occurs...
(Multi-page thread 1 2)
February 11th, 2004 07:51 AM
by Roger Govier Go to last post
14 577
Extract Text Outside of Brackets by Frank Kabel
Hi if you have only one textpart within brackets for each cell you may try =LEFT(A1,FIND("",A1)+1,1024) to get everything except the bracket text...
February 11th, 2004 08:38 AM
by Frank Kabel Go to last post
2 413
Hour and Minute Differences by Niek Otten
6:52 is correct. Why should it be 6:32? -- Kind Regards, Niek Otten Microsoft MVP - Excel
February 11th, 2004 09:55 AM
by Niek Otten Go to last post
0 120
Excel indicator for when a future date is reached! by glenrayel
I have a finance company which works on a 30 day pay period. The spreadsheet I created for this is getting very large and it is becoming difficult to scan for...
February 11th, 2004 12:55 PM
by glenrayel Go to last post
0 393
Minutes and Seconds by Lynn
I exported a spreadsheet that contains mm:ss (1:10), but when I pull it up in Excel it shows 70. Like it added the minutes and seconds. How can I convert...
February 11th, 2004 01:11 PM
by Lynn Go to last post
2 83
Sources and Uses by BldrBldr
Hope you can help. Looking to solve for value "X" which makes the sum of "Sources" equal to the sum of "Uses", that is, how much do I need to break even. It's...
February 11th, 2004 04:22 PM
by BldrBldr Go to last post
2 235
Post New Thread


Display Options
Showing threads 4041 to 4060 of 87787
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:43 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.