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
Sum by sgrech
Hi, I have a following data in a column on my spreadsheet 0.00 -98.35 #N/A -222.89 56.45 0.00
October 23rd, 2004 07:18 PM
by Frank Kabel Go to last post
2 180
Penny rounding! by rozbat
Gordon, the trouble is not that I can't do as you've suggested, the problem is that almost all the columns are showing errors because of the tiny roundings up...
October 23rd, 2004 04:17 PM
by rozbat Go to last post
0 143
Changing values daily by George Gee
I would like to know if this is achievable? I would like cell B30 to show whatever is in cell F10 If the value in cell F10 changes, then the new value to be...
October 23rd, 2004 03:39 PM
by George Gee Go to last post
4 296
Penny rounding! by rozbat
When using the "if" function on the function wizard, I'm having problems with penny rounding. I have three columns. Column 1 is a net figure, and column 2 is...
October 23rd, 2004 02:24 PM
by Gordon Go to last post
1 159
Conditional Formatting by George Gee
Hi all I have this conditional format in cell BB35 =IF(BB35$BB$37,TRUE) If I insert cells between BB35 & BB37, then the formula changes to...
October 23rd, 2004 01:31 PM
by Debra Dalgleish Go to last post
5 169
combining columns by mudraker
one85x In c2 enter this formula =right("b2",4) & left("a2",1) -- mudraker ------------------------------------------------------------------------
October 23rd, 2004 06:18 AM
by BenjieLop Go to last post
1 172
Update selected columns from one spreadsheet to another by homevestors
Hello, I have two spreadsheets saved as seperate files with different names. One is sheet is called parcels.xls. The other...
October 23rd, 2004 02:40 AM
by Mark Go to last post
1 185
Deleting Blank Rows by PA
I am frequently importing data from other applications, into Excel 2002 workbooks. There are, many times, blank rows, with no pattern or in no way similar to...
October 23rd, 2004 12:17 AM
by Frank Kabel Go to last post
1 271
How do I create an employee schedule and vacation tracker? by Excellent
Never used Excel for this but I know it can be done.
October 22nd, 2004 09:34 PM
by bigwheel Go to last post
2 274
IF Function by sgrech
Here is a nice easy one! I have a value in a spreadsheet that I need to check. If the value -0.005% or 0.005%, then I need to notify the user that an...
October 22nd, 2004 09:31 PM
by Bob Sweet Go to last post
2 175
Uppercase Input by L.A. Lawyer
I want to format a cell so that any characters inputted into that cell are automatically saved as uppercase in that cell. How do I do that?
October 22nd, 2004 09:28 PM
by Peo Sjoblom Go to last post
2 191
need more columns by Herm
Have used up all columns and need about 60 more can I add then and how or do I need to look at redesigning, can't rotate work as again still not enought columns
October 22nd, 2004 05:23 PM
by Frank Kabel Go to last post
1 142
update month itervals automatically by Odart
If say something was done in May-04 and it's not due again for another 15 monthes how do I get excel to due the math and then when it get's done in 15 monthes...
October 22nd, 2004 05:13 PM
by Peo Sjoblom Go to last post
2 154
macro cannot be found by Ydiv
I created a macro and called it Timestamp_on_save. It was originally supposed to populate a cell with the current time and date upon hitting the 'save' button....
October 22nd, 2004 11:23 AM
by Paul Cunliffe Go to last post
1 291
I am getting the error message "Cannot open consolidation source . by richuber
I am trying consolidation for the first time. I set up 3 files with data to consolidate, then i went to data -- consolidate, entered all the reference files...
October 22nd, 2004 08:37 AM
by JulieD Go to last post
1 163
how do i locate student data files in excell by vigilba
I am a student trying to use microsoft office xp for students and teachers, I am having trouble finding the storage location of the student data files.
October 22nd, 2004 07:39 AM
by JulieD Go to last post
1 149
Custom filters by Dudley
I created a custom filter on a city field, looking for all cities that start with So. The criteria used was begins with SO. THis works fine. I then...
October 22nd, 2004 05:50 AM
by VENKAT Go to last post
2 184
Audits by LMB
Hi Everyone, I am using Excel 2000 and am a beginner. We are going to be doing some QI testing for our department in our hospital. We will be looking at...
October 21st, 2004 09:06 PM
by LMB Go to last post
2 149
Displaying durations in Excel by Verbatim
I have a worksheet which calculates a duration in hours...is there a built-in number formatter that could display that as h:mm:ss? How would I create...
October 21st, 2004 06:15 PM
by Verbatim Go to last post
2 181
goal seek command function by Mark
Can you give me an example of how to input value to get a specific result for the goal seek function;i.e, what values do we input in the boxes to get...
October 21st, 2004 02:09 PM
by VENKAT Go to last post
2 148
Post New Thread


Display Options
Showing threads 12721 to 12740 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 03:39 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.