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
multiplying a negative time value by a monetary rate by apogee
hi there, I have a cell that contains a negative value, which I need to multiply by a rate. I have set to 1904 system, what I would like to do is if the cell...
June 13th, 2004 12:37 AM
by JE McGimpsey Go to last post
1 488
Underline Accounting by Bruinlax
How is a good way to make the underline accounting underline the WHOLE cell? for instance - i want 4.0% to be ______4.0%_ not _4.0%_ i've tried _(* 0.0%_)
June 13th, 2004 12:44 AM
by AlfD Go to last post
4 487
Links tutorials - resources by David McRitchie
Hi Mustafa, You have additional answers in excel.links You have asked the same question several times in the Excel newsgroups. Basically you are not...
June 13th, 2004 12:48 AM
by Peo Sjoblom Go to last post
1 431
Timesheet Formula Problem by Bridie
I am trying to set up a timesheet to cover staff working 24 hrs. Day and night hours are paid at a different rate (and staff members all have different rate of...
June 13th, 2004 12:49 AM
by NickMinUK Go to last post
3 419
Tab Fonts by
Does anyone know how I can change the font color on the worksheet tabs? Thanks in advance. Mike in Chicago
June 13th, 2004 12:57 AM
by Gord Dibben Go to last post
2 350
WRAP TEXT by LYNN
I HAVE TRIED TO DO FORMAT, CELLS, ALIGNMENT & WRAP TEXT...IT DOES NOT WORK. I'M TRYING TO DO THIS IN A CELL THAT HAS BEEN MERGED WITH THREE OTHER CELLS TO THE...
June 13th, 2004 01:42 AM
by JE McGimpsey Go to last post
2 527
Automatic chart generator by Jon Peltier
Michal - I have some suggestions on this web page that would make it easier to select which data to...
June 13th, 2004 02:04 AM
by Jon Peltier Go to last post
0 608
Autofilter - are number of rows limited? by NickMinUK
I have a spreadsheet some 20 columns wide by 6000 rows. Autofilter has been applied to all columns on the header row and has been working without any problem....
June 13th, 2004 02:15 AM
by NickMinUK Go to last post
4 748
Moving programs by greg
Can anyone advise how to remove a program from Excel to another program such as MSWord. I have a file that is incompatible with Excel.
June 13th, 2004 02:30 AM
by Gord Dibben Go to last post
2 357
On Open by Ian
Can anyone help me out with this? I want a worksheet to preform these actions each time it opens: Automatically unhide any hidded rows (especially...
June 13th, 2004 06:08 AM
by Frank Kabel Go to last post
1 397
VLOOKUP several conditions by Ron H
I have two worksheets, one with customer data and financial data, and a second with salesperson information. I need to "import" the salesperson from the...
June 13th, 2004 08:33 AM
by Aladin Akyurek Go to last post
6 569
logic doubts by nowfal
I am using a work sheet for billing purpose, for that i need some security options for certain cells where i put currency rates, the format is as follows: A ...
June 13th, 2004 11:26 AM
by Aladin Akyurek Go to last post
3 370
How do I run multiple instances of Excel? by Scott
In Word, each file opens in a separate instance of Word, with its own Taskbar entry, etc. But with Excel, if I click on a second .XLS file, it opens in the...
June 13th, 2004 01:40 PM
by Debra Dalgleish Go to last post
2 632
Worksheets - Visibility by Doria/Warris
Hi, My Excel workbook has got many worksheets and in addition they have quite long names. As you can imagine, I have to scroll the horizontal bar continuosly...
June 13th, 2004 03:45 PM
by David McRitchie Go to last post
2 474
Conditional Formatting by Art
In Excel 97, is it possible to have more than 4 conditional formats? Maybe up to 6 or 7. I am looking at changing the color of a row (say columns A through H)...
June 13th, 2004 04:14 PM
by JE McGimpsey Go to last post
4 647
Lists obtaining additional information by engmgriff
Hi I have created a dynamic list. From this list I would like (depending on what the user has chosen) another list which represents the list they have chosen...
June 13th, 2004 04:17 PM
by JE McGimpsey Go to last post
1 468
summing based on auto filter by Art
I have a spreadsheet with several hundred rows and many columns. The formula in column "C" sums values for all columns from "D" through the last column for...
June 13th, 2004 04:19 PM
by JE McGimpsey Go to last post
2 1,100
deleting spaces by Continental Translations
In a column of cells, tha majority of cells have spaces before the text. As there are over 500 cells, is there any easy way to delete these spaces? As there...
June 13th, 2004 04:54 PM
by Ragdyer Go to last post
2 506
spliting words up by Continental Translations
In cells A1:A502, I have a few words in each cell. These words are split up by a colon. So, for example, in cell A1, it says "Today : yesterday", cell A2,...
June 13th, 2004 05:06 PM
by Ragdyer Go to last post
3 623
Bold deletion by Yarroll
Hi, I run a macro which checks if specific cells' font is bold. If it isn't, then the whole row gets deleted. The lines in question read: For k = howm To 2...
June 13th, 2004 05:10 PM
by Yarroll Go to last post
3 460
Post New Thread


Display Options
Showing threads 41 to 60 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 09:58 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.