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
Formatting Dates in excel by Keoni2008
I have about 2000 rows (x4 in columns) of dates in 2 formats and they are "0/00/00 and 00/00/0000". How can I quick fix this problem into just one format...
May 29th, 2010 12:53 AM
by Tamer Paksoy[_2_] Go to last post
3 192
cannot open Excel (.xls) attachments in Outlook by childofthe1980s
Hello: This Vista user has Office 2007. For the past two weeks, he has been unable to open .xls files in Outlook. I have tried everything from newsgroups...
May 29th, 2010 12:11 AM
by childofthe1980s Go to last post
1 248
MS Excel 2007 "Recent" files not updating by John Gee[_2_]
When I go to the Start button, then click on Excel 2007, a window opens showing Recent files. For whatever reason, these are not being kept recent, but are...
May 28th, 2010 11:12 PM
by Jim Cone[_2_] Go to last post
1 228
AUTOMATICALLY ENTER AND CALCULATE NUMBERS AS NEGATIVES by EarthAngel
I used custom format so that I could automatically enter several negative numbers without keying in the minus sign each time. However the column did not...
May 28th, 2010 11:11 PM
by EarthAngel Go to last post
3 216
formatted colored text by Brenda
When I format text and/or numbers to be in color, it continues to show as black and white on the screen. What am I doing wrong?
May 28th, 2010 10:22 PM
by Gord Dibben Go to last post
1 136
If statment by Cerealkiller via OfficeKB.com
If g44 equals 0 then h44 it is returning it as false maybe i am missing something =IF(G44=0,H44) -- Message posted via http://www.officekb.com
May 28th, 2010 10:09 PM
by Cerealkiller via OfficeKB.com Go to last post
5 107
export data between excel files by scott
how do setup an excel file that each time when I enter data it will export to another excel file in the same column of subsequent rows? Thanks. Scott
May 28th, 2010 09:28 PM
by Gord Dibben Go to last post
1 272
TIME SHEETS by puzzled
I am trying to design a template to do timesheets with. How do I create a formula that will read in time, out time, lunch time then total for the week? ...
May 28th, 2010 09:09 PM
by Gord Dibben Go to last post
1 225
printing selection by Anniel
I want to print a selection. I select the proper cells, but there is an extra row that prints at the top. It is always the same row, so perhaps I have it...
May 28th, 2010 09:06 PM
by Gord Dibben Go to last post
2 93
pivot to represent multiple occurances as 1, but link to all ocura by cv8497
I have a list of data in which I wat to pivot to show only the number of different occurances in column "A"(this example is two-bub & ubu) but i also want it...
May 28th, 2010 09:05 PM
by Billy Liddel Go to last post
2 183
combine formulas into 1 by DebC
In the examples below, is it possible to combine the 2 formulas into one? I need to simplify my spreadsheet if...
May 28th, 2010 09:00 PM
by Luke M[_4_] Go to last post
1 143
Addition function of multiple cells by DB74
Does anyone know if there is a function that will take a list of numbers in different cells and run various addition combinations on the list to detemine...
May 28th, 2010 08:55 PM
by Lars-Åke Aspelin[_4_] Go to last post
9 276
If statment problem by Cerealkiller via OfficeKB.com
I have Excel 2000 I am trying to make this IF statement work. What I want to do is if H44 equals a number 1 to whatever then use colum N44 if H44 equals 0 then...
May 28th, 2010 08:39 PM
by Don Guillett[_2_] Go to last post
5 143
One partial table, one master table - update the partial by boilermaker
I've got a listing of 3000 personnel. Personnel in column A, supervisors in column B. In a separate worksheet, I have a listing of 400 personnel in column...
May 28th, 2010 08:33 PM
by boilermaker Go to last post
3 146
updating seperate spreadsheets with same data by T
I have seperate spreadsheets, one with monthly numbers and one with yearly numbers. how would I go about updating a clients info in the monthly spreadsheet...
May 28th, 2010 08:31 PM
by Luke M[_4_] Go to last post
1 139
Booked locked for editing properties by RFW
How do you set the properties so that whoever is in a workbook and you get the message "...locked for edtiting" Isn't there a way that each person from their...
May 28th, 2010 08:30 PM
by Luke M[_4_] Go to last post
1 153
Matching pairs of Data in cell by whatzzup
Good day, i would like a solution to this problem. i have a set of data in a spreadsheet, these could be repeated, what i would like to display pairs of...
May 28th, 2010 08:25 PM
by Squeaky Go to last post
1 136
updating two seperate spreadsheets with same info by T
I have 2 seperate spreadsheets one with monthly info and one with yearly info. I wondered if there was a way to update the same info in one spreadsheet and...
May 28th, 2010 08:17 PM
by Don Guillett[_2_] Go to last post
1 217
Text to Column will not cooperate by Going Crazy with excel[_2_]
Looking to separate two names in a cell, separated by a Hyphen. It will not separate the names. Is there a formula that will work to separate them? Example: ...
May 28th, 2010 08:16 PM
by Don Guillett[_2_] Go to last post
2 223
links not working HELP HELP HELP by Michele
In our office we use copy links in Excel and special paste them into Word documents and we are having great difficulty updating our links when we open our...
May 28th, 2010 08:11 PM
by Squeaky Go to last post
1 170
Post New Thread


Display Options
Showing threads 301 to 320 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:30 PM.


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