Excel - general questions on using Microsoft Excel

Thread preview

Thread	Last Post	Replies

Array problems	28 Sep 2006 21:36 GMT	4
I have the following formula using 3 name arrays of Day,City,columL. ColumL is a sum of L11:L19. I am receiving the #Value error. I've tried every way I know to solve this. Any ideas?? =SUM(AND(Day,"=Sunday",City,"=West",columL)).
Insert ' sign infront of dates	28 Sep 2006 21:23 GMT	5
i have the current visable values May-06 Jun-06 Jul-06
Changing 1234.00- to -1234.00 automatically	28 Sep 2006 21:20 GMT	7
Everyday I have to copy and paste data from a program to an excel spreadsheet. Positive numbers come in fine, negative numbers don't. They align to the left of the cell with the negative sign to the right of the numbers. Currently I: F2, backspace, home, put in the - sign and ...
Why does this formula not work?	28 Sep 2006 21:18 GMT	21
Why does this time formula NOT work if I leave out '(E8<D8)'? The formula works normally when written as below... =(E8<D8)+E8-D8 When I leave out '(E8<D8)', the cell shows #########
RIGHT Arguement?	28 Sep 2006 21:01 GMT	7
If the number 123456 was displayed in cell A1, how could I get the fifth digit (5) displayed in cell A2? TIA
Why won't text in cell wrap. Cell format set to wrap.	28 Sep 2006 20:27 GMT	2
The text in the cell only wraps when I click on the text. As soon as I move the focus away from the text it goes back to unwrapped. The format of the cell is wrapped.
Formula starts =+(cell reference)	28 Sep 2006 20:19 GMT	3
Can anyone provide a detailed explanation of what it means when a formula is input into a cell with the addition sign immediately after the =. Examples: =+a1, =+C:\Excel\[WB]Sheet1!A1, =+L187+(Q213), =+Sum(A1:A33) I inherited several spreadsheets that I am revising that use this ...
How to print only the used portion of excel spreadsheet?	28 Sep 2006 20:18 GMT	4
When printing a 5 page excel spreadsheet, printer wants to print 1200 pages. Can I get it to print only the pages with data (the first 5)?
Countif Function in Two Columns	28 Sep 2006 20:15 GMT	2
I have a little problem I am trying to count the # or occurences in once column as it relates to a specific object in another. An example is below. ColumnA ColumnB LA Cancel
replace question	28 Sep 2006 19:24 GMT	4
Hey guys! I have 2 columns A and B. What I need to do is take what is in column A and replace a string of astricks in Column B. For example: Column A Column B Result
Numerical patterns in Excel	28 Sep 2006 19:20 GMT	3
How do I create a pattern of 50? Example 32001-32050
On Excel I need to round up in tens of thousands	28 Sep 2006 18:51 GMT	3
On Excel I need to round up to tens of thousands... e.g. 158000 to 160000 or 21500 to 30000... Does any one know this formula???
Paste Array	28 Sep 2006 18:48 GMT	1
I have an array Array(750,200) I want to paste the contents into the worksheet, i tried Sheets("Sheet1").Range("C1:GU750").Value =
Another replace question	28 Sep 2006 18:14 GMT	2
Hey guys! Thanks for the help on the last question! Here is another one. I have column A with this text: sometexthere=moretexthere
How do I change default colours and print settings for Excel2003 (WinXP) ?	28 Sep 2006 18:09 GMT	1
How do I change the default colours and default print settings for new Excel2003 (WinXP) files ? With thanks Ship