I would like to recode data in Excel, i.e., making 5 become 1,
making 4 become 2, making 2 become 4, making 1 become 5, to change the
direction of negative-worded item questions.
   Might anyone know how to accomplish this task in Excel?

I am trying to add
5:49
1:50
3:00

I am not a professional software developer, nor a GUI designer.
I need help in improving the GUI of my Excel spreadsheet application.
I currently have a few cells that user put their inputs, and then 4 buttons
in an array that they can choose to click and execute. That's it. I feel ...

I have a worksheet where C3 contains a dropdown menu of 8 items, for example
radio,tv,microwave,stove,other.
I would like B2 to change color if C3 contains the word "other"
and I would like B3 to change from locked to unlocked only if C3 contains

Can a cell be edited if the contents are the result of a vlookup function
and still keep the rseults? I have 2003 on an XP Pro PC. My formula is
=IF(A4<>"",VLOOKUP(A4,InvDetail!$A$2:$B$3000,2,FALSE),"")
I trying to create an availability list for our customers but need to add

Suppose I have an Excel spreadsheet where all the hyperlinks point to
a server, for example
\\sn230aa\documents
and I want to globally change all the hyperlinks to

There is a simple form in Excel: one button, and one textbox. The button
has a CommandButton1_Click() procedure defined as a call to the
following subroutine:
Public Sub ChooseUniverse()

What code do I use if I want only numbers and not text typed into a textbox?
Thanks...

Is there a way of making some of the vertical (dividing letters) and
horizontal ( dividing numbers) lines appear heavier (darker) than the others
to accentuate group divisions?

I am having a strange problem with excel 2007.
If  open an excel sheet and then close excel the normal way everything is
fine.
If I then reopen excel again and try to close it the normal way nothing

Excel 2007
Is there a 'trick' to unhiding rows? I hid rows 3-5 in my worksheet and
now no matter what I do I cannot unhide them. I have tried selecting row
2 and row 6 with the same result, the hidden rows stay hidden. All of my

I've used these google groups a couple times in past month and you've
all been really helpful.  I hope I will be able to contribute
sometime, but alas, it looks like I have one more question, if anyone
could help that would be awesome!

Using Excel 2002 (XP)
I know how to remove the Integer of 14.67 and end up with .67.  But how can
one remove the decimal portion and leave the existing Integer 14?
Thanks,

Hi experts!,
I have created a workbook with a macro (assigned o a button), which
saves the workbook under a different name when the macro button is
clicked based on the infromation entered by the end-user. Accordingly

I'm using the PMT formula and it is correctly calculating the figure I need,
but always saves it as a negative number.  Is there a way to change this so
that it is a positive number?
Thanks!