General

Maintain Formatting with Formulas
I am writing a formula that references multiple cells as the possible source cell depending on certain parameters being met. My question is whether anyone knows how to maintain the formatting in the display cell? My possible source cells all contain different number formats (i.e. -1234.0 and ##00.0E-+00). Is... 17 Jan 2010 23:57

How do I calc loan payments with 6 equal pmts & 6 at zero?
-- Brian Cloke ... 17 Jan 2010 22:51

Allocating percentages
I have percentages in B2:B30 which add up to 100%, and an amount to allocate in A2 (for example, 8). However, the results must be integers, and must add up to A2. The simple formula is =round($A$2*B2,0) copied down, but the rounding doesn't always produce the right total. How do I ensure that the total always e... 18 Jan 2010 17:42

Stop multiple cells from being automatically selected
When I place the cursor in a cell, it selects that cell and the 3 directly below it. Why is this happening and how do I stop it? I have already exited the program and even rebooted. Thanks. ... 17 Jan 2010 13:57

cell color versus gridlines - Excel 2003
The default white cell color causes my eyes to strain after a while. In Office 95 and 97 I somehow made all the cells a very light gray by default and had the gridlines in black by default. For the life of me, I can't seem to do this in Office 2003. Any tips? Jean ... 17 Jan 2010 15:04

how to print a master sheet together with another sheet
i need to print a master sheet with a result sheet it is in the same workbook but on a different sheet but i need to print them on one sheet ... 17 Jan 2010 06:11

Copy a column and paste to another tab to save the data for ea
Thank you very much for your help and quick responsed. It work base on the month change . -- thanks Liem Pho "Don Guillett" wrote: Option Explicit Sub CopyColHtoEstimatesSAS() Dim ms As String Dim dc As Long 'line below ONLY needed if firing from another sheet 'Sheets("Merchand... 16 Jan 2010 22:44

Wht can't I open Excel files from Sharepoint any more?
I'm running Office 2007 and IE 2008 on a Windows 7 pc at home. Ever since the last round of Windows/Office updates was installed (1/13), I haven't been able to open Excel files from my company's Sharepoint site. MS Word files open ok, but when I try to open Excel files, nothing happens. There are no error messa... 17 Jan 2010 16:12

About Macros
Dear All, i am itrested to write my own macros, But i dont know anything about macro, i always copy the code and use. i want to make my excel spredsheet, from where to start macros, how to start, and what is macros pls i want to learn macro pls help ... 16 Jan 2010 12:48

Excel user enter a store # to query Access data base
I have a file when the user enter a store # 13315 and hit a update button the marco will go to access data base to query this store and bring back data. we found out if there was more than 5 users from 5 different location the error will cause the spread sheet do not return data. How can I write a message to po... 15 Jan 2010 23:50