Regional option is set to a locale where decimal symbol is the comma. When importing text data that has numbers with periods, XL '02 and '03 automatically...

Hello. I have two questions. I have a macro that opens a bunch of files, does stuff to them and then saves them based on the contents in a few cells. Is...

Excell 2003, XP Pro. A user downloaded data from the internet that uses the Acute Accent character instead of a standard single quotation mark. Sometimes....

I am wanting to create multiple excel files that all contain the same information however I want them all to be based on a template so when I update the...

Hi, I tried to save a neew sheet with a new name as usually I do with 'save as' under 'file' in worksheet menu bar. But now I am totally surprised. there is...

How do I eliminate unwanted rows and columns to right and bottom of my document ? Jeffrey S

I am running Excel 2002 on two machines installed from the same set of Office Disks. On one of the machines, when I go to Autocorrect to enable Smart Tags,...

Hello, Is there an easier way to open an IP connection to my networked printer? currently I've been trying to use: Private Declare Function WSAStartup Lib...

Excel 2007 It used to be the case I could move the curser using arrow keys, this is no longer the case, I have to select a cell with the mouse. What setting...

Hello, I need to know if there is anyway to automatically change the source data path for a multiple consolidation range pivot table. I know that I could go...

I am needing to be able to open my excel sheet and have it automatically highlight the expired dates. For example, if I opened the sheet on November 10,...

In a golf league consisting of 24 players in six teams of four players each week over 13 weeks, how can I make sure that no two people play together too...

Office 2007, Xp Pro I have cells with text format, ie 0117401342 How do I format to 011 740 1342?

I am using a pivot table to track data. (1) I want to color code fields to track the occurrences of my data. Used Conditional Formating, but does not remain...

There is a lot of information in each sheet and they need to be merged. Each sheet had a unique ID which matches with each other (ie one sheet hadd addresses...

I am trying to set up Excel on my new computer (a Vista 64 bit). For some reason(s) or other, Excel is seriously wanting to file all my Excel files he...

When opening links in excel, the default program to view seems to be IE. I would like to change that program to one of my graphic viewers. How can I...

I saw a worksheet in Excel that was a form comprised of about 10 columns and 20 rows. All of the space surrounding the used area was grayed out, so the page...

Have I posted this in the correct group? I have a stored procedure (named MyProcedure in this example )that runs, a connection in Excel that is set up...

I have an array of data where I don't want errors to display. I tried using a conditional format where I would set the number format to ";;;"...