General

how do i print from excel to envelopes
mailing address and return address print directly to envelopes or labels from excel ... 29 Mar 2010 15:52

Formatting a number as a date
When applying the keyboard shortcut CTRL+SHIFT+# to a number, Excel formats that number in the 29-Mar-10 format by default. How do I change that default format for the current and all futire workbooks? ... 29 Mar 2010 18:07

Formula Help
I need a formula that will translate a percentage change into a word. For instance; if the percentage of cell a1 is negative 5% or greater I want cell b1 to transcribe "LOWER PRICE" if the percentage of cell a1 is 5% or greater I want cell b1 to transcribe "HIGHER PRICE" if trhe percentage is between -5% and +5... 29 Mar 2010 17:00

Sorting whole Protected 2003 REDUX
We are working in Excel OS Name Microsoft Windows XP Professional System Manufacturer Dell Inc. System Model Precision WorkStation T5400 Microsoft Excel version 11.8320.8221 (Excel 2003 of Office Professional Edition 2003) We are trying to sort and filter protected cells. In the Protect dialog, we have ... 29 Mar 2010 10:15

Removal of 100's of spacing in numbers
I want to be able to use the replace command, but it won't find the spaces for me. When I copy tables with numbers from various sources, I get spaces inside and after the numbers. E.g. “1 234 “ I know the use of SUBSTITUTE and other functions, but it is not an effective way of working when there are so many... 1 Apr 2010 03:36

Calculate Dates
Source Data coming in this format 19880716 would like to calculate the difference in years between the source data date and the date 01/01/2010. How would I write this formula. Appreciate anyone help-- NINA ... 29 Mar 2010 10:15

Specific Date from a Range
Hello, I have a spreadsheet that has a column of dates that look like this: Activity Dates 2/15/2010 03/01/2010-03/31/2010 03/01/2010-03/31/2010 03/01/2010-03/31/2010 03/01/2010-03/31/2010 03/01/2010-03/31/2010 03/01/2010-03/31/2010 03/01/2010-03/31/2010 03/01/2010-03/31/2010 03/01/2010-03/31/2010 2/28... 29 Mar 2010 10:15

Macro?
Excel2003 ... I know nothing of writing Macros ... I only "record" them & edit ... The following Macro is in a Pivot Chart WorkSheet of my WorkBook ... Issue is ... this Macro randomly activates an annoying "debug" pop-up. When this happens I simply select END in the pop-up & all is fine ... & ... Macro works... 29 Mar 2010 10:15

Link?
Excel2003 ... When my WorkBook opens it asks to "Update Links" ... I think I can break this Link??? ... I can see what WorkBook I am Linked to, but I do not know what depends on this Link in this WorkBook??? In my WorkBook ... How do I see what depends on the other WorkBook? Thanks ... Kha ... 29 Mar 2010 10:15

Please help very urgent ageing by if condiction
I have three column in my excel sheet 1. Month 2. year 3. Amount 4. Period In period column, I want to show 1. if the month is current month it should be shown as ' Curnet' 2. If the previous month it should be shown as '30' 3 if before previous month it should be 60 4 otherwise '120' Please help ... 29 Mar 2010 09:08