General

Pivot Table doesn't display all data
It displays all the data for example on month of data and will not pick up all the data from another month? -- Gator ... 2 Jul 2008 23:13

Format cells to make zeros not appear,or be invisible on scree
And to think of all of the times I thought I was being so clever by using Conditional Formating to make the font white on white when the value =0. Feel the release! "Jim Thomlinson" wrote: Tools -> Options -> View tab and uncheck Zero Values -- HTH... Jim Thomlinson "RajenRajput1" ... 2 Jul 2008 11:54

Remove decimals
I would like to change 1.53 to 153 using a formula or format change. What is the easiest way to do this? I know of a couple ways to do it but would involve multiple steps and am trying to avoid this if possible as I am not the one using it. Thanks, Matt. ... 2 Jul 2008 12:56

Formula for looking up blank and/or date-filled cells- contingent
Hi: Column A is called 'Receipt Deadline' (mo/dd/yr) Column B is called 'Actual Receipt Date'. (mo/dd/yr) Column C would be called 'Outstanding Receipts'?' (yes/no/'N/A') I want Column C to look in Column A and IF there is a date entered there, then look up column B and see if there is a date entered there as... 2 Jul 2008 12:56

Format cells to make zeros not appear,or be invisible on screen &p
Hi, Does anyone know how to format a cell so that it looks empty when a zero is put in? I am using the custom number format of #,##0;(#,##0) so that I can put company accounts onto a sheet, where negative values appear in brackets. I want to extend the format so that zeros appear as blanks (or rather, they... 2 Jul 2008 11:54

Combo Box that allows user entry of values not on drop-down list
I'm creating a form that requires some drop-down menus. However, I want users to be able to type in their own entries if the choices in the drop-down lists are not applicable. From what I can see in Excel Help, I need to use a Combo Box with Active X control. Then, it says to go to Properties (in Design Mode... 2 Jul 2008 11:54

Excel text formula
How can I exclude a cell containing text from a "sum" calculation in another cell? ... 2 Jul 2008 11:54

Storing a range variable in a cell
I am writing a VBA script and I need to frequently load and store a range as a long-term variable. How do I store an actual range as a variable so that I can have a function load it and save it? I need to do this because I am using the Application.OnTime function and will need to call a subroutine to execute ... 2 Jul 2008 10:52

SUM ignoring errors
Is there an easy way to sum a column but have it ignore #NA and #Div/0! The file I am using is fairly large and I'd like avoid build IF formulas to replace the errors Thanks ... 2 Jul 2008 12:56

number to date format
how do convert a cell with 8 numbers 19680422 into the date format 4/22/1968 ? ... 2 Jul 2008 10:52