I tried formatting with a created "Custom" format of "yyyy-mm-dd" and that works EXCEPT, it doesn't affect dates before 1900. Why wouldn't it, and how...

I have a genealogy data sheet and one column contains dates. I have formatted the column various different ways showing month/day/year, etc. If it is...

I have a simple calculation C8-C14 that I use to figure my budget difference. It works in all the monthly columns I have set up except for one. I get...

How can I make my 2007 Excel Workbook to always defaulyt to showing the full bar ribbon under the HOME item. What happens now is that when I choose home,...

In a worksheet I have, I have set the vertical alignment to 'Top' however, the text seems to stay at the bottom. Navigation Right click Format Cells ...

Hi all, in a excel sheet i want to generate the following sequences for some array of numbers let us say starting from 0 and going to N-1 bits, the sequence is...

I have a table that looks like the following: Col.A Col.B Col.C Col.D Col.E Row.1 4 ...

For all cells in a column, E2 - E20, that contain a value of 0, how can you change the value to a space while making no changes to cells containg a value 0?

I am using the following format to query another sheet and return data. =(SUMIF('Assignments Formulas'!B$5:B$251,B4,'Assignments Formulas'!R$5:R$251))/2 It...

Hello, I’ve got two columns with staff ID numbers which I’d like to firstly match and then sort so that identical ID numbers are on the same row. For...

Hi, I have data per 10 sec (Huge COLUMNS) and would like average it per 1 minute and per 10 minutes afterwards. I found some info about 1 hour data...

Hello, I would like a solution to my problem. I have a formula with a result in "G1". How can I bring over the result into cell "B1"? Once I closed out...

Can I take the contents ("WD4") of a cell (A2)on Sheet1, look for a match of the code ("WD4") on Sheet2 in cells A1-A20, and return the coresponding text in...

WTB: MICROSOFT OEM SOFTWARE WTB: MS WIN 95, 98, 98SE, 2K, XP, OFFICE 2000, XP, 97, 95 PRO-Vista ultimate, basic, premium Small business.. Looks at the list...

While typing the headlines I just want to fit in the particular colunm by down wards.

I need to show a loan amortization and I don't have a clue what to do. Here's the data. 8.5% interest rate compounded monthly loan amount 47,500.00 24...

this is probably a basic question, but here goes... I have a worksheet where staff will be slowly filling in dates into one column and I want Excel to...

I have two similarly structured XLS file. One file "A" is much longer...perhaps 2000 rows long...when saved as a htm file it is around 500KB. I take...

Hi, Can anyone please help me. I was trying to enter the below no in excel. 0000081563 But when i enter it in the excel cel. it becomes 81563. how can i...

Hi I run Excel 2003 under WinXP I have inherited a number of spreadsheets from another person. One of these sheets keeps putting an error up that says "No...