Somehow the columns labeled with letters changed to numbers.  How do I get
them switched back?

I need to track to retain the first value of a date field.  Each time
I load the worksheet the date field has the potential to change, I
need to keep track of the initial date in addition to the current date
that is in the field.

I have an user which uses alot of formulas. Updates ran about 2 weeks ago
and since then any spreadsheets she worked on she needs to set the
calculations from manual to automatic.
When she does start a new spreadsheet calculations is set to automatic, but

How do I stop my Personal Macro file from requesting to be Saved each time I
exit Excel?  This is very annoying and has just started happening after
creating some macros to update data from certain clients.

I have a bunch of fractions to input.  They are all in 32nds of an
inch.  The cells are formatted as Fraction - up to 2 digits.
Unfortunately, "As 32nds" doesn't show as one of the options; so 2/32
automatically reduces to 1/16, 16/32 to 1/2, etc.  Can I get

I occasionally get CSV or regular Excel files that have line-feed
characters in cells. This causes cells to have multiple lines in them
(you can also create them by using ALT-ENTER). I would like to know if
there is an easy way to break up these cells into individual rows,

Hi everyone,
   I have a problem hopefully some one can help me out with.  
I have the following 4 dates…
Beginning Date of Service

I would like to have a macro on a Button on sheet 3 that would do the following
Go to B1 on sheet 1 and find the lAST entry on col B
Now I want the Data that appears on the last row of col b to be printed on
Sheet 3 cell A!

The following problem only occurs in certain tabs in only one of my
spreadsheets.
When I enter a date -any date- it returns "1/0/1900."  I have entered
various dates and formatted the cells as numbers, and the cells return

i´m trying to obtain the max value, but i need to have a reference
ex:
client  value
123     1560

Hi, my question is a little weird but i can explain it hopefully well
enough that someone can help me. At y workplace we have approx 400
computers to monitor. We have 3 seperate systems to monitor these
computers, and every computer must be reporting in to these 3 seperate

A) I use Ron de Bruin's script "Copy records with the same value in a
column to a new sheet or workbook". How to add VB code that totalize
one of the columns and write the value under the last row?
See the script http://www.rondebruin.nl/copy5.htm

I extract a list into a .txt file and then open in excel.The list
contents are from a dynamic source, but contain certain text items
that are constant. I want to be able to prompt for the word and then
find the next instance of that word in Row D, then navigate three

I have a sheet where I need the total no of entries in column C.
I have used
Text in col C         =+CODE(C30)    =+IF(D30>1,1)
and SUM at bottom of col E [I was not able to use COUNTA].

Is it possible to convert dollars automatically into euros in Excel 2002? I
have downloaded automatically updating currency rates using MSN Money. Now I
would want to make a cell in which I could enter the amount in dollars and
see the amount in euros in the same cell. Is this ...