I have produced a custom number format that will format positive numbers in blue, negative numbers in red, it enters zero values as 'n/a' and text...

Ok. Thanks to the discussion group I was given the following custom formatting setting so that I could round numbers. $#,###,, "Billion";$#,, "Mil"; $#,...

I am trying to track magazine volume/Issue numbers. What I need to do is have a formula that can add numbers to with a custom number format. The problem I am...

I an using the TEXT function because I want to show a number in a cell without that number being picked up in SUM functions on the worksheet. I want the text...

I have a spreadsheet with tariff numbers in a column already in the following format: 9018.90.8000 and I want to be able to: 1. eliminate the "periods" in...

Is it possible to save custom number formats? I created one that I want to use often but everytime that I close Excel and reopen it, it has disappeared out...

Excel 2003, Windows XP Pro, Service Pack 2 loaded. Needed: The type underline you get with the accounting format (see below for details) when you are using...

I need help.. I have a column (Meet criteria) and the data is 'Yes' or 'No'. When I do a pivot table, and I drag the field (Meet criteria) as column and...

Is there any way of placing re-curring values in footers for workbooks with multiple sheets. For example a version number or project title. I do not want to...

Is it possible to specify a formula that creates a custom numbering format. For example, I want to set up a column that can do...

I am trying to open an excel 2003 workbook with custom sort in excel 2007. I get an error that points to "a sort state that uses a sort condition with a...

Can someone give me the drill on how to manually sort a field in a pivot table. Please do not repond if you are not planning on answering exactly what I am...

Hello, I'd like to sort a sheet based on an ID column, but have the order customized. The first part of the ID would be customized, the last part ( after...

We keep track of the version of a file by using Prepare-Properties-Document Properties-Advanced Properties-Custom-Document number. Is there a way to have...

I cannot for the life of me get my custom template worksheet to show up in the same location as the default xlt files. My PC is a company machine but my help...

Is there a way to use OTHER icons than the one that are currently available by "Chanage Button Image" Thanks -- Norton Professional 2004 says this email is...

I'm hoping someone can help with this problem I have a workbook created in excel 2000 with macros in it and also a custom toolbar. When I open the workbook...

I have a file that is a master file. Each user opens it up and does a Save As and names it accordingly. There is a custom toolbar attached that does some...

How can I make a chart with two series of Columns and one serie of line? For example, I need to, in the same chart, show Product A's and B's net sales from...

I am using Custom Type Charts in Excel, which uses Pivot Table as the Data Source. The problem that I am facing here is that whenever I Refresh the data...