When I double-left click on a cell in a pivot table, I can drill down and see the underlying data; however, it shows me this data in another worksheet. To...

format the cell as mmmm dd"," yyyy will give the result, set it up as a custom format, Format Cells Custom (at the bottom of the drop down list box) set up...

try here for the converter. Or save as an excel file from quattro. Macros can be a problem. I have quattro 4.0 and 5.5 so if all else fails and it is a SMALL...

I am downloading data from a web site to an excell worksheet, data as displayed is 23:6-4-3. I want to paste it as text, but excel changes it automatically to...

Hi Folks, This one has me scratching my head! First, I should state that I'm fully aware of the glitches involved with math operations being translated from...

Help Please - And thanks in advance to anyone who can and does! :) My worksheets are named by member_id (a number), on my first worksheet, the summary...

I'm trying to use the SUBTOTAL command to sum up columns of filtered data. I'm using "Advanced Filter". I have 56 columns of simple numerical data. I have...

Happy New Year to all very helpful people in this NewsGroup. Could someone please help me with this one... What I need is: Everytime I open my workbook I...

Dear all, I want to find a 2004 calender in Excel format, who can help? Thanks

I am looking for a way to remove multiple hyperlinks at one time. I know I can right click and go to hyperlink, remove hyperlink, but this works for only one...

I need help with a formula A1 1 A2 yes A3 3.00 A4 10 A5 20 A6 25 A7 22 A8 30 A9 2

I need help using OFFSET to define a named range that constitutes the 3 most recent (last rows) in a larger range that tracks trend data, so my chart based on...

Since indirect won't work with closed files, couldn't u use indirect to make the reference and then just copy/paste special values? -- Don Guillett SalesAid...

I am having a problem formatting cells to currency for data that was imported into Excel from a text file. It was imported in the format 49420. 8 but will not...

Dear community, I'm at a loss understanding, why in the middle of a simple table I get scattered #N/A errors, where at other places of the column the function...

How do I freeze pains in both a column and row at the same time?

Can anyone tell me how to proper case an excel spreadsheet? thank you

- MAKE EZ AND FAST CASH, NO JOKE, JUS READ!!!!! : MAKE MONEY FAST!!!!!! IT WORKS!!!!!!! : IT'S SIMPLE AND IT'S LEGAL!!!!!!! I found this on : a bulletin board...

I need a new row to insert automatically when I am finished with the current row. Here is the kicker it also needs to carry all my formulas with it. I will...

First I want to wish everybody a Happy New Year with a lot of Excel fun For anybody that is interested or use a earlier version of the Google Add-in There is...