Everytime I input a number it is divided by 100 so 100 is displayed as 1 and
1 as 0.01. It is happening with new and old files. I have tried the format
cells but always recognises as /100
Any ideas greatly appreciated.

when i highlight some cells and try to format them nothing happends,
workbook and sheets are not protected, cells in question dot not have any
data in them at all, totaly blank!
if they are locked how can i findout? and how to unlock them?

After reinstalling, all my applications are working ok except Excel.
1.  Every time I start Excel I get a message that Windows Installer is "Installing: Microsoft
Excel Feature", and on the bottom left, I see that ATPVBAEN.xla is opening.
2.  The templates that are installed with ...

I'm trying to have displayed, somewhere in the footer, the total numbe
of pages printed (rather than just the total number of pages); so if
have one sheet and print it twelve times it say the page total i
twelve on the sheet

I had something sent to me in an e-mail that I could not open.  It was sent in Adobe.  I have Adobe reader but it wouldn't work on this e-mal.  They then sent it to me through Excel.  I could not figure out how to open it.  I finally had to call and get it faxed to me.  Can you ...

During a VLookup,
(A 1400 name list, looks for matches in a 150,000 array)
The seek time takes just under 12 minutes,
there is no "hourglass" indicating the program is computing

Any way to select a different sheet without using the mouse
--
Message posted from http://www.ExcelForum.com

I am currently creating a template.  My final stumbling block is creating
an auto incrementing cell in the template.  What I want to happen is that
every time the template is opened, the next sequential number fills in the
cell.  The format I am looking for is basically yy-#####. ...

I have two workbooks with simple identical formulas that update
control number after the macro runs. One workbook is ok. The other wil
not update the control number. Instead, it changes the cell referenc
to one row higher and returns the previous control number. Here's wha

Okay, I have posted many times over the past few years about these darn
spreadsheets.  I appreciate all the help in the past.  I picked up a few
things here and there, but I just can't get over the hump and fix these
worksheets so I don't have to keep managing them.  I will go into ...

I hope I can explain my problem if you need further details please advise:
I have 6 Option Buttons (Form Control) on a worksheet, when I click
(Checked) any of them the rest automatically unchecked themselves, how can I
modify them, since I want to create two groups of 3 Option ...

I am trying to create raffle tickets in Excel, and I need to have a ticket number on the bottom of each ticket (starting with 001).  Is there any way I can make the program automatically add the numbers, or will I have to do it manually?  There will be five, two-inch high tickets ...

There are some hidden columns in a Excel file.
When I open that excel file using below code and then perform some
operations on Excel file and then save the file back and view it, all the
original hidden columns are also being shown.

Good morning all,
Can anyone help me on a little matter regarding what seems to be sticky keys
in excel?.
We use both Excel 97 and 2000 here, and I just had a couple of problems from

Any help will be appreciated
I am working on a spread sheet for fiancial analisis.  In doing so I
sometimes enter data for two quarters/years or four.  I then set up a
cell for the total increase/decrease.