How do I change the cell alphabet to default?
Currently it is showing DCBA rather than ABCD in the correct order.
Would reinstalling office work or is it based on the spreadsheet itself?
Thanks in advance.

I wanted this macro to accept the date the user gives in the dialog
box.  In all the sheets on the range v6 it should put that date but it
should only be on sheets2 and onward not on sheet1. I wanted it to
only ask for the date once.  This macro asks for the date on every

I have app 1500 numbers in col A.some as single digits,others are in the
ten's or hundred's or thousand's such as 1,12,123,4567 etc
I want a maccro that will do as follows:
If col a1 = 1 I want it to look like this "2007 0001"

How to group percentile?
I have the follow time sheet of employee paid scale. I need to group into 1
to 4 pay percentile groups, for example, the lowest paid 25% into group 1.
Column A (number of employee)    Column B (Pay Scale)    Column C Percentile

is there anyway to keep two separate excel files "grouped" ie always
associated with eachother. i have two models that i would always like
to open at the same time. the plan is to open them, then write a macro
that transfers data from one file to the next

Does anybody know how you can increase the number of items that show
in the drop down Name Box Field. Currently there are 7, but I am sure
I have had it set up with more in the past. Thank you for any
suggestions.

I had this macro in a workbook attached to a button on sheet1.
Sub months()
   'count the number of worksheets
   Sheets(1).Select

Hi all (again)!
It seems that from one day to the next I am suddenly in the need of
performing odd things using VBA.This time I need to get the current
formula on a chart's title. I'll proceed to explain a little bit why I

I have a complex spreadsheet and we have run out of columns on several of the
worksheets.  I use Excel 2007 my client uses Excel 2003 so I hope the file in
compatibility mode.
If he installs the compatibility pack would he be able to see the increased

I am working with a sheet containing numbers in cells between 1-6, I only
need the numbers 4.5 or greater, and average those numbers. what is the
formula for it to determine say cells A1:A30 only the ones >4.5 + the average

I am using state of the art excel 97 at work.
When I type in a number "4" it comes up as .04, when I put in "400" I
get 4.
First thing I thought was precentage, ok so I changed it to number

Totally confused...!
Where do I set the default font in Excel '07 for hyperlinks? Its
automatically putting "calibri" font size "11". My workbooks are always Arial
font 8. This is a pain...!!!

I'm having a problem with Excel 2007. Whenever I open documents (all are
stored in 97-2003 format) Excel stops responding after a few minutes. I have
to say that the documents are opened for reference only - I do not modify
anything, just browse.

I am using Excel 2003 and am importing live data into a sheet. Everytime
the page loads the current data is pulled in from an SQL 2000 view.
The person who wants to use this spreadsheet wants to put an extra
column in the middle of the data. I have created a null column in the

I have an excel spreadsheet with thousands of rows of data in the format all
in Column A:
Row 1: COMPANY NAME 1 Address
Row 2: Contact1