I need to change the default settings for importing .csv files into Excel so that I don't have to change the settings every time I do the action. Is this...

It seems that my file has duplicated itself. When I open the file in Excel 97, there is actually two (2) "files" that open. When I click on "Window" drop...

Hi, Mistakenly I removed the previous post... That I pasted some parts below. Actually Jacob helped me on highlighting the renewal date with 10 days window...

-------- Original Message -------- Subject: Run macro on exit worksheet/workbook Date: Tue, 02 Aug 2005 22:47:57 +0200 From: toontje Organization: Versatel...

I saved a file in Excel, but at the top after the file name it now displays . I can no longer auto filter my data. How do I remove this ? Thanks!

at the top of my screen beside my file name is this, . i don't know how it got there but now every time i change a cell in one worksheet it changes that cell...

What causes the word to appear in brackets after the filename in the Excel 2003 Title Bar?

It seems I've somehow keyboard shortcutted my way into a grouped spreadsheet. I can't sort, I can't undo... I can still add to the spreadsheet though. There...

hi- i've had to make a single edit across 90 some-odd sheets in an excel file. i did this by selecting sheet 1+shift+sheet90 sometimes the title of the...

I have an Excel question. My spreadsheet has a 'group' status to it. For example the file name is....tiffs spreadsheet.xls and is displaying as....tiffs...

next to my open workbook name, there is a . What is this and how can I remove it? Thanks Thrava

What does it mean when a spreadsheet title finishes with ? Why is it not possible to sort the information as A-Z ? -- Billy

Dear Experts, May I ask you what the following function does? Format cells → Number → Custom → : mm:ss. Thanks.

Vorrei fare una cosa apparentemente semplice ma che mi sta cmq sfuggendo di mano : il codice seguente dovrebbe cancellare tutte le celle dove è scritto #N/D in...

Is it possible to get the length of a particular field. For example I would like to copy the contents of an identification card, which has - a number of...

I would like to retrieve a list of contents from cells that are not hidden. For example, copy sheet 1 a1 to sheet 2 a1 if cell is not hidden copy sheet...

I would like to create the following formulae: A1: Start date/time e.g. Thursday 25/06/2009 08:00 B1: End date/time e.g. Thursday 25/06/2009 18:00 C1:...

I'm trying to calculate a formula as follows: Effective interest rate = principal amount / (principal amount - interest paid upfront - loan charges) - 1 I...

I have a bit of a problem calculating a financial formula that gets the outstanding principal amount as at the end of month. My understanding of the formula...

1. I would like to return the first calendar day of a week number and the last calendar day of a week number, any ideas? For example, I have week numbers 11...