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
Draw table in Excel 2007? by Janis
How I can draw a table in Excel 2007, like in 2003?! I searched the useless Help and sites, but find nothing. Anybody knows?
March 29th, 2009 01:28 PM
by Janis Go to last post
5 142
[newbie] copying a date value by Jon
I'm trying to get the date value in dddd dd/mm/yyyy format, however, when using this formula, the date returned seems to be the "excel serial...
March 29th, 2009 10:52 AM
by Jacob Skaria Go to last post
2 155
AutoFill A to Z by Hardeep kanwar
There is an Option in Excel to AutoFill Like want to Autofill Sunday ,Monday or January, February Or 1,2,3 like this Is it Possible to Autofill A,b,c,d,e...
March 29th, 2009 07:59 AM
by Hardeep kanwar Go to last post
4 238
After IF formulae - how to extract results into other sheet? by MikeR-Oz
HI, I have applied a IF statement to Colun H with results in Column I, (thanks to this group on showing me how) BUt now I would like to condense the...
March 28th, 2009 10:16 PM
by MikeR-Oz Go to last post
4 154
Importing an OpenOffice file in .ods ext (Excell format) by jejpa
I am new to Excell and would like to import an OpenOffice .ods file in Excell. Can anyone tell me how to do this.
March 28th, 2009 07:20 PM
by Gordon[_13_] Go to last post
2 176
Find File by LC in Boston
I am trying to open an .xls file that I created a few weeks ago - that is listed within a folder. When I click to open I get a message that it can't be...
March 28th, 2009 04:38 PM
by Kassie Go to last post
1 119
convert a sum to a number that can be moved to another location by peteFL
Can I convert a sum number to a number that can be copied to another cell minus the formula.
March 28th, 2009 02:09 AM
by Dave Peterson Go to last post
1 156
Other option for IF(AND( )) by wilchong via OfficeKB.com
Dear sir, There are 2 data sets is assumed running in A1 down, viz.: (i) In A1 down is showing a set of date: 2009.03.26; 2012.12.31 and 2015.12. 31 (ii) In...
March 27th, 2009 10:34 PM
by JeffL Go to last post
2 134
How to edit text in colum by Michelle22
I have a column of phone numbers listed as 1-555-555-5555 and need to format it to 555-55-5555 (removing the 1-) and I can't find it anywhere. Can anyone...
March 27th, 2009 08:55 PM
by Bernie Deitrick Go to last post
3 153
Getting Combo boxes to change options based on other Combo boxes. by Ancient Wolf
Using Excel 2007. I am trying to create either Form Control Combo Boxes or ActiveX Combo Boxes that will change the selectable options based on selections...
March 27th, 2009 07:29 PM
by Kassie Go to last post
1 157
Mode function - return default value rather than #N/A error if no by Struggling in Sheffield[_2_]
Hi, I'm using the following expression to return the mode of a list of numbers: =IF(H1028="","",MODE(H1028:H1031)) If the four checked cells all have values...
March 27th, 2009 07:27 PM
by Domenic[_2_] Go to last post
4 348
Updating Pivot by acss
Do i have to rebuild the pivot table after i add additional rows of information to the data sheet. It seems that when i add data and i do a refresh on the...
March 27th, 2009 06:48 PM
by Roger Govier[_3_] Go to last post
4 136
When I click on a column, that column and one to its right is sele by Larry6295
For some reason, on my first spreadsheet, when I click on a column, the one to its right is also selected. It doesn;t happen on all the columns. What did I...
March 27th, 2009 02:22 PM
by Dave Peterson Go to last post
1 301
Formular for the SECOND highest frequency by wilchong via OfficeKB.com
Dear sir, I have an excel formular which involve 5 cells, A1, B1, C1, D1 and E1. The value in cell from A1 to E1 is 2, 6, 2, 2 and 6. In the cell of H1, I...
March 27th, 2009 07:46 AM
by wilchong via OfficeKB.com Go to last post
8 156
Printing of pages by Charles Eaves
Sorry for the newbie question. Can you specify in Excel 2007, the order for pages to be printed out without manually rearranging them yourself? Thanks
March 27th, 2009 12:11 AM
by JBeaucaire[_92_] Go to last post
1 126
Working out difference between 2 shown dates by Deltic
I currently have a column which contains a date and time data (20/06/2008 16:30) time / date occured and a second column containing similar data (24/06/2008...
March 26th, 2009 09:44 PM
by Luke M Go to last post
1 83
a2=a1-32 how do i hide -32 until I have a value in a4 by jackdaw999
the box a2 contains the formula =a1-32. how can i get rid of -32 that is shown in all the boxes the formula applies to a2 down to k2 thanx
March 26th, 2009 09:31 PM
by Gord Dibben Go to last post
1 101
Want to show only values higher than'x' from otehr column? by MikeR-Oz
HI I have several columns - the last is a series of values that goes on and on. I want to create a column next to it that will identify only thhose values...
March 26th, 2009 05:09 PM
by Alan Go to last post
5 124
how can i open an e mail with attached file that ends with xls by ganymede
hello i got an e mail with attached file that ends with xls and i cant open
March 26th, 2009 03:24 PM
by Luke M Go to last post
1 147
Converting a CSV file to an Excel file by Gordon Biggar
When I export a file from a website to an Excel file (on a Windows 2000 platform), it shows up in Excel as a standard Excel spreadsheet (I am using Office...
March 26th, 2009 03:17 PM
by Gordon Biggar Go to last post
3 129
Post New Thread


Display Options
Showing threads 1881 to 1900 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 05:18 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.