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
excel only writes 0,0001 instead of 0,1 by Florian
My Excel 2000 seems to have a problem. I can no longer write a normal "1" without correcting it manualy. Interestingly the problem is only with the "1" no...
May 13th, 2009 11:46 AM
by Florian Go to last post
4 120
EMBED VLOOKUP AND SIMPLE IF FORMULA IN A WORKBOOK by Angela
Hello friends, I have a set of work sheets in a workbook. sheet1 name is (DATA) sheet2 name is (SALE) In sheet SALE, cell B2 value is either blank or...
(Multi-page thread 1 2)
May 13th, 2009 11:40 AM
by joel Go to last post
10 168
Change colour of rows in a worksheet by VJ Sharma[_2_]
How can I change each nth row's colour in a worksheet?
May 13th, 2009 11:14 AM
by FARAZ QURESHI Go to last post
1 154
CONDITIONAL SUM ("OR") by FARAZ QURESHI
Sure would oblige if any of you experts devise a formula to calculate the sum of column E of the following table, wherever an "X" is present in any of the...
May 13th, 2009 09:32 AM
by Jarek Kujawa[_2_] Go to last post
8 116
Is This a Pivot? A SumProduct? A SumPivot? Matrix? by RJB
Received a report from Excel, a survey. Sixteen respondents, each row of the report is one answer to one question from one respondent. In other words: RESP |...
May 13th, 2009 07:31 AM
by Pecoflyer[_336_] Go to last post
1 104
Data Source for Dropdown Lists by Lynda
A colleague of mine was sent a spreadsheet that had a number of dropdown lists. One of the dropdowns had lost its data. My colleague asked me if I could fix...
May 13th, 2009 06:24 AM
by Jacob Skaria Go to last post
5 99
Charts using List Feature by DS
I use charts to sales by month in Excel 2003. Names are displayed in column A and Months in Row 1. I love the List Feature and how it adds new records...
May 13th, 2009 04:29 AM
by Jon Peltier Go to last post
1 131
can Excel show display bookmarks similar to Acrobat by Matt Hewson
I am trying to create a catalogue and it would be simple to use and update if I can use something like the bookmarks that Adobe Reader uses. Regards, Matt
May 13th, 2009 04:27 AM
by FSt1 Go to last post
1 118
How to add a "0" (zero) to the front of existing data in cells by Primbarbi
If anyone can help, I'd appreciate it..........so I don't have to add a "0" to the front of a million cells......
May 13th, 2009 04:10 AM
by Hotrie Go to last post
6 108
Excel error - Highlighting duplicate values by Johnson27
I have a column of data in which I'd like to have the duplicates highlighted. However, when I select this option from the Conditional Formatting drop-down,...
May 13th, 2009 04:08 AM
by T. Valko Go to last post
2 141
Check Conditional formatting in 2007 by COB
In Excel 2003 there is a way to cause all conditionally formatted cells to highlight in gray. It's to check if you've formatted all the intended cells...
May 13th, 2009 04:00 AM
by T. Valko Go to last post
1 196
help,,, going from to lotus to excel by excel challanged[_2_]
is there a program available for use, i need to convert a lotus 123 file to excel any ideas ty
May 13th, 2009 03:22 AM
by FSt1 Go to last post
3 104
Drop down and formula by Japessebas
I have a worksheet with over 1000 entries. One column has a drop down menu with a choice of 6 inputs, another column has different numbers on each row. I...
May 13th, 2009 02:23 AM
by Eduardo Go to last post
5 130
How to open XML data file? by JoeU2004
I am trying to open an XML data file (I think). I am having trouble following the Help instructions. The instructions say: click on File Open, then...
May 13th, 2009 02:12 AM
by JoeU2004 Go to last post
2 88
Date dd/mm/yy in the cell, but mm/dd/yy in formula bar by sfp
I am being supplied a file that displays date as 06/05/09 in the cell, but 05/06/09 in the formula bar. Cell is displaying the value I need, formula bar is...
May 13th, 2009 01:48 AM
by Dave Peterson Go to last post
1 92
Conditional formatting scrambled when combined with sorting in 200 by COB
How can various CF's in the same column stay referenced to their relative cells when a sort is applied? eg I apply a specific CF to values in column B that...
May 13th, 2009 01:15 AM
by COB Go to last post
2 152
Formatting a cell with a formula by Jim
Hello, In would like help with adding a dash to a series of numbers. I know I can format with special formatting using 0-00. However the result does return...
May 13th, 2009 12:54 AM
by Alan Go to last post
7 117
how do I double or triple an existing EXEL file by floatinghawk
how do I double or triple an existing EXEL file
May 13th, 2009 12:53 AM
by Dave Peterson Go to last post
6 158
Reduce File size by Jeremy Ng
Hi, We have 1 file which previously have alot of sheet into it & file size is very big, now we delete all sheets except keep 1 sheet with a simple table &...
May 12th, 2009 11:50 PM
by Bill Sharpe Go to last post
4 123
O.T. Google Search by RagDyeR
I realize that I've not been around these groups as often as in previous months, and might have missed a thread on this subject. I was searching for an old...
May 12th, 2009 11:26 PM
by RagDyer Go to last post
4 132
Post New Thread


Display Options
Showing threads 20241 to 20260 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 08:24 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.