For some reason, everytime i am typing a number in excel, the last two
digits are made into decimal. For example, if I type "1,023" into a
cell, once i hit enter it becomes "10.23" in the cell. How do I fix
this? Thanks

I have a couple of issues and I'm not sure from where they're rooted. I've
been trying to install Adobe CS3 with issues. I'm not sure how that relates
other than there was a flashpaper addin at one time and I had problems with
it not going away in excel. Now it's gone from excel ...

Cells.Select
   Selection.Sort Key1:=Range("E1"), Order1:=xlDescending,
Header:=xlNo, _
       OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

I have a file with several drawings, text boxes, etc. I now cannot see
them nor can i add any new drawings, text boxes, etc., to this file. I
might have accidently hit some shortcut key sequence to hide them. How
do i get them back?

I'm creating a workbook of twelve Excel sheets for recording and calculating
UK HMRC Approved Business Mileage claims on a monthly basis.
The current HMRC rates are:  40p/mile for the first 10,000 miles, followed
by 25p per mile thereafter.

Cross posted since I have gotten no responce in
microsoft.public.excel.programming for 3 days
Ok I've seen the 1,000s of people trying to program page setup
options

I need to create a unique data from a spreadsheet with the design as below:
       1/1/07    2/1/07     3/1/07 ...... (date at row 1)
9am      abc      xyz       (empty)
11am    rst       abc          xyz

Thanks to all that pointed me to data validation...works great. Now I can
use data validation for pull down menus....but I want to put addresses of
customers into a list...so I can use them to invoice quicker...this is easy
if I put the addresses into one cell and use the list. Is ...

This is probably really simple - but how can i count how many cells in colum
contain a certian text varible ?

1) IZIT we have to memorise for the format for logical function AND, OR
e.g. IF(OR(.....),(value),)
Is there a more effective way for understanding???
izit when there are 3 IF we use IF and OR 2gether and if there are only 2 we

I have a cell that contain a text field that says " Input - Manual" .  What
I want is when I print I don't want to show this cell, only the other
contents in the worksheet.  Is this possible.  Thank you in advance.

Using XP Pro SP2 and Excel XP (2002)
Like to know if it is possible find all duplicate entries?.  Can not use a
starting string because it's unknown having all kinds of possibilities.
I text pasted a file directory with paths and filenames, I can have

Each time when I sorting, Excel always include header row. Is there
any way to exclude header row when sorting?

I use WinXP Home, Excel 2003, and Norton I/N Security.
Several years ago, I created several macros, and associated toolbar buttons
to perform some common tasks:  formatting cells for dates, decimal, whole
numbers, and inserting and adjusting column widths.  They've functioned

I am plotting a chart in Excel 2003 using non-sequential data points
as shown below.
Time     Value
0             0.07