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
Can i get a formula to change hours into currency £ by David Wilson[_2_]
I am looking for a formula to change working hours i.e (78h 30m ) into currency i.e £6.00 £6.00 x 78:30 ( h:mm ) = £471.00 Excel 2007
May 17th, 2009 11:34 PM
by FSt1 Go to last post
2 697
calculation-iterations by widman
Is there any way to set 1 worksheet for iterations so that it doesn't return the circular reference, but leave other sheets working normally?
May 17th, 2009 11:42 PM
by art Go to last post
5 634
excel links by Struggling with If, Then
I have a series of workbooks linked by multiple "If, Then, Else" equations - 50 per cell, approximately 200 cells per workbook. When I try to send the...
May 17th, 2009 11:43 PM
by art Go to last post
1 603
Up down arrow keys do not select cells if select locked cells unch by roandrob[_2_]
If I protect my work book and do not allow selection of locked cells the arrow keys and enter key do not select cells ( unlocked ) in the up down direction....
May 18th, 2009 12:48 AM
by roandrob[_2_] Go to last post
3 582
Find and Replace Command by ManhattanRebel
On the Find and Replace Command, under the look in option, the only choice I am given is "formula". I would like to specify that Find and Replace look in...
May 18th, 2009 02:07 AM
by FloMM2 Go to last post
1 186
Tools key and add ins? by Flemmac
I'm new to 2007 Excel, where do I find the Tools button so I can select Add Ins?
May 18th, 2009 02:51 AM
by Jacob Skaria Go to last post
1 156
Server time from Local Time by jaxstraww
I play on a games server that uses the 24 hour clock for reporting. Issue is I'm 6 hours behind server time. I would like to have my real time calculated...
May 18th, 2009 03:54 AM
by T. Valko Go to last post
6 239
Why is only the last column available in the Excel worksheet? by ajie
When I open Excel, and move the mouse, the cursor goes to the last column of the worksheet, and does not allow to go anywhere else, except in the column IV....
May 18th, 2009 07:29 AM
by HelpExcel.com[_2_] Go to last post
1 218
Formula based on format of cell by ant
How do I create a formula based on the format of a cell? For example, I want to add up all values of the cells that are red. Can I do this? How?
May 18th, 2009 08:20 AM
by David Biddulph Go to last post
3 147
COmparing a cell with a colum of data by Dingerz
Hi iam having trouble wiht my formula =IF(A2='Area 43-52 New Floc Upload'!$A:$A,"New","Old") or even =IF(K12=L1:L15,"YAY","NA")
May 18th, 2009 08:54 AM
by Jacob Skaria Go to last post
9 183
convert data into barcode by BAKERSMAN
I am trying to convert data from specific cells into a barcode. I have the correct barcode font loaded but cannot seem to get a couple of the cells to give...
May 18th, 2009 09:21 AM
by Jacob Skaria Go to last post
1 171
want to highlight cell which having comment & greater than 0 by Devender
Want to highlight only those cell which are having comment and their value is greater than 0
May 18th, 2009 10:06 AM
by Gary''s Student Go to last post
1 180
How do I get synchronized windows? by harry46
In 1-2-3 you used to be able to force two windows viewing the same sheet but widely different rows to keep their viewed columns oin step. This facility still...
May 18th, 2009 10:13 AM
by harry46 Go to last post
4 186
Calculation by dhstein
I'd like to speed up the calculations on the spreadsheet. As a first step, is it true that only cells that get changed and those cells that have...
May 18th, 2009 10:31 AM
by Pecoflyer[_344_] Go to last post
2 195
reinstate smart tag by Phippsy
Once you have selected to ignore a smart tag is it possible to bring it back?
May 18th, 2009 10:33 AM
by Phippsy Go to last post
0 205
Auto Formatting hours of .csv file by The Rook
I have a .csv file that is populated with hours (for example 28:53 when open as text file) When I open it in excel it automatically formats any hours that...
May 18th, 2009 11:10 AM
by The Rook Go to last post
2 149
Help using VLOOKUP command by Scott
I have 144 unique data fields in cells B5:B148. Each of these data fields is individually located somewhere (not in order) in cells K5:AH148. What I want...
May 18th, 2009 11:45 AM
by Jacob Skaria Go to last post
7 188
Embedded files by Lindae
I have been receiving excel files with embedded files (.mp3) with no problems. Today I cannot get the .mp3 files to open. The timer keeps going and task...
May 18th, 2009 12:08 PM
by joel Go to last post
1 195
Calculation by dhstein
I'm trying to understand Excel's methods and rules for recalculation. My workbook (very large about 9 MBytes) takes about 7 seconds to recalculate. If I...
May 18th, 2009 12:35 PM
by dhstein Go to last post
2 179
Auto filling formula by Skibee
Hi I have lots of formulas to enter following a similar pattern - can I auto enter them. The pattern is as follows ='All Data'!B6, =B2+'All...
May 18th, 2009 12:51 PM
by Jacob Skaria Go to last post
3 181
Post New Thread


Display Options
Showing threads 119761 to 119780 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 03:11 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.