Enter "s" to record   
B                 C              D
call #     timestamp    timestamp
1    s    1:34:29 PM

Back in the early 90's when we first got Excel, I created Pop Up Dialog boxes
in the worksheet.  The way it worked is when you opened the worksheet you
would click on a button to get started.  The first pop up box would be
something you would create that would have a question, ...

I received an excel file that was converted from several text files.
When trying to sort and vreate pivot tables it would not allow me to
group the data by date.  I reviewed all the data and found some cells
in the date field were numbers such as 12/31/05 but others were

I am looking up data on another spreadsheet within the same document and I am
not getting any results returned. Can a formula expert look to see what I am
doing wrong please?
Spreadsheet with formula is named Index:

I have a workbook with 63 worksheets in it.  All of the worksheets are
formatted exactly the same.  Is there a way to make a master sheet that will
average all of the worksheets and be in the same format and layout?

After export from Access, the Excel column containing numbers and text has
green triangles in the cells because it is formatting the numbers as text. I
would like this column to export as General format.

Can Formatting Painter be used to format multiple rows withiout having to hit
the Painter Icon multiple times?  Thank you!  -  rms

How do I write a formula that would evaluate a cell and return different
values?
IF cell = 1 or 2, return "A", if cell = 3, 4 or 5, return "B"

What causes a long number - 555116311212 - to colapse into 5.55E+11?  When I
try to widen the cell the number now reads 555116000000.  I am using this
spreadsheet as .csv to import and this change in numbers causes duplications
in numbers and interferes with the import.

I have a list of numbers 1-50.... if I delete a row, I want the
numbers to automatically adjust.  The formula I had was
in cell A1 -- 1
In cell A2 -- A1+ 1

I am doing monetary calculations in an excel spreadsheet (great place to do
that, huh?).
Sometimes the calculated value is $0.00. Which is not a problem. The problem
is that sometimes the value is displayed in red.

Excel XP
I'm wanting to know if there is a way to enter a range of numbers (Example
0-10) and have the background be a certain color.
Example:  I enter the number 5 in a cell and then the background would turn

I have 10 checkboxes that perform similar functions with a minor variation.  
I'd like to make one "click" event subroutine but change the action depending
on the name of the control that initiated the event.  Inside the subroutine,
is there a way to determine which control was ...

I'm using MS Office 2003.  Recently, I've noticed that I'm unable to see the
embedded Excel data in either my PowerPoint or Word documents.  The link and
outline are there and active, because when I double click on the "ghost"
outline, it opens the appropriate Excel Worksheet.  ...

how i can use vba programming in excel 2007 to sort in column in
ascending order give me reply as a i am beginner.