General

General number formats changing to Dates or Euros
Thanks Paul and Gary's Student. I used a combination of your ways, but found another as well. Below changes the default "Normal" Style back to General Number Format. So far this seems to work. Sub FixDefaultNumFormat() ActiveWorkbook.Styles("Normal").NumberFormat = "General" End Sub Thanks again ... 2 Feb 2010 17:28

Pivot table bottom ten filter with conditions
Hi is it possible to have the bottom ten item of a pivot table but excluding specific value(s) eg I have a pivot table with the bottom 10 of cost item 1 -200 $ item 2 -300$ item 3 -0$ .... I would like to exclude item that have a cost = 0$ and have only items greater than 0. thanks ... 5 Feb 2010 09:25

Saving as webpage, uploading via FTP
I cannot upload my spreadsheet (saved as webpage), via ftp, through Excel. I can successfully save the file on my computer, access the ftp server via Internet Explorer, and then drag the file. For some reason, when I try to use the feature in Excel, and upload the file to the same location, I get error messag... 2 Feb 2010 17:28

How to correct cannot access directory 'J:\\'.
I no longer have a flash drive that I had previously used. How can I get past this error? ... 2 Feb 2010 17:28

automatically insert autoshapes when cells are updated?
Excel 2003 Hello, I am wondering if anyone can help me with a macro (or other technique) that will automatically insert an autoshape only once a cell is populated. Also, whether the attributes of that autoshape can be determined by what is entered in other cells. I am trying to develop a visual represent... 2 Feb 2010 17:28

How do I copy formula but only increment certain ranges?
I'm having a similar problem to martc's. I'm working in Excel '07, trying to drag down an Hlookup formula. The formula I'm using is: HLOOKUP("ABCD",A$1:AB$2881,2,FALSE) Originally I had no "$", once I put them in, it locks the return row at 2 instead on icreasing 1 with each additional row. Changing manuall... 4 Feb 2010 19:08

Excel 2007 - Formatting text in cell (character by character)
In Excel 2003, one could select a cell, highlight a part of the contained text string and then right-clidk and format text. I could get underlining, bold, font, color, etc. For some reason, with Excel 2007, I can do the same, but when I hit the enter button, the formatting disappears. It reappears if I select ... 2 Feb 2010 17:28

Macro to Copy Sheets to new workbook
Found this macro by Dave Peterson and want to modify it so that I can do the following: Select the ActiveSheets and Copy them to a new workbook - BUT I do not want to copy the formulas. Only want to copy the values, formatting (row height and column width), sheet names, hyperlinks. But NOT the formulas. The ... 2 Feb 2010 17:28

Why does sheet formatting change when pasting into a new book?
When I select Move/Copy... for a sheet in Excel 2007 and select a new workbook, sometimes the formatting changes. Usually the charts will have a new color scheme, and cell colors will change to strange color schemes as well (bright red and green, anyone?). I am copying from one XLSX file to another, both file... 2 Feb 2010 17:28

Tabs
In my ACCESS program, the Home, Create, External Data,.....etc tabs are all expanded. In EXCEL the tabs must be clicked each time to use the columns underneath. Is there a way to make them stay there. I can't figure it out from the help column ... 2 Feb 2010 17:28