I want to input time data onto a sheet, in the format of a 24 hour clock
(e.g. 09 45 or 17.30 etc).
However, when I select the hh:mm format from the time format options and
then input, say, 19.30, I get a strange date first and then a time which is

i am moving our address book out of "Word" into "Excel" for ease of use can i
still print onto envelopes as i did in Word

I have a excel file with student names, status, highschool name. I want to
merge it into a word document (memo) that is directed to the highschool.
There are several names and status' to each highschool. For example: there
may be four names and status' with one highschool. How do ...

In cell A1 type =B1
now in B1 type the number 10.
A1 looks at B1 and shows the value 10.
If I then cut the contents of B1 and Paste them into C1, A1 will still show

How can I validate data entry into a spreadsheet for a specific cell where
an email address is typed into? One of the common errors my data capturers do
is using a comma instead of a full-stop.
Thanks

I used to have one workbook:  raw data on some worksheets and pivot tables
and charts on other sheets.  
The raw data sheets were actually exported to the workbook from Access.  Why
not do charts in Access?  Because the charting formatting features inside

I have a spreadsheet that uses columns A - Z, in some of the cells up
to here, I have the word 'yes'.
I need to know how to calculate the number of 'yeses' in the cells to
come up with how many I have.

Can I attach alerts to dates in an excel spreadsheet, for example so that a
reminder will go off in my outlook when the date arrives?

I know that in the old days you could turn on the display of menu hotkeys on
a MAC - identical to the underscore of the letter F in File, E in Edit....  I
also know there are hotkeys for MAC dialog boxes, but how do you get these
hot keys to show which letter is the accelerator ...

I am using Windows XP and Excel 2000.  I have 2 worksheets ‘People’ and
‘Data’.  In the worksheet ‘People’ I have the code below, which displays a
count total , where the date is between 01/04/2007 and 30/04/2007 in cells in
column A, cells in column C match “A16”, cells in ...

If I have a table:
Apples           red           9
Oranges        orange      6
Lemons         yellow       2

Is there any possible way when I am updating information in one tab to make
sure it transfers the info to a second tab to update the information there?
For instance I have in Tab A information on several trucks such as year make
model VIN etc. In Tab B I have the years of the ...

I'm looking for ways to customize the GUI on excel2007, at present if i
highlight an array of cells the area i highlight is a very pale almost white
yellow. If i then ctrl+drag select a different area of cells it is almost
impossible to see what areas i am highlighting and the ...

I know there is a way to add the same cell (say G3) across multiple tabs,
without  simply Pointing to each cell on each tab. I cannot remember how.
Help?

Hi I have a macro that prints to one specific printer on the network so one
person can file all the quotes people enter. Other computers but not mine,
mine is the emailpc. All computers have the printer driver. Its a peer to
peer network. I think it has something to do with the ...