I am wondering if you guys may be aware of a hardware or a software
product that can provide me the capability to put scanned table data
in
a spread sheet format. For example, I make a Xerox copy of a data table

Before a hyperlink on an Excel spreadsheet is run a box appears, like a
mouseover, showing the  hyperlink path. Is there a way to stop the box from
appearing - THANKS!

I have a spreadsheet that does the following on a weekly basic,
First Name    Surname        Total    SPH    Sales      £    Attendance   
                            %
Claire     Jepson        32.00    0.37    10    £40.00    100

hi can anyone tell how to block cells and colums
basically i have a spreadsheet and i need to protect the formula and
contents of above 20 cells in 2/3 colums and don't seem to find a way to be
able to do it.

Can somebody help me on which function do i have to use.
1. I need to count the number of (example 22403248 equivalent to
ANSWER)
then answer should be 3

Right everyone will probably know the answer to this- but it has been some
time since ive used excel.
I have a spreadsheet of values- how can I multiply every value in the table
by 0.6?

how do I get more than 3 conditional formats?
I want to shade the cells depending on the 9 values (criteria range) each
one a different colour
thanks

Thanks very much for all the answers, I went through the posts and learnt a
lot, but I could find exactly what I need.
The problem I've got is that one of my criterias is part of the cell.
So, to be clear; I need all the cells which start with the word "pipe".

I have multiple similar autofiltered worksheets in a workbook as like
below.
My goal is calculating Line adherence(LA) and Quantity adherence(QA).
Quantity adherence very simple to me.

This is probably easy but I haven't been able to figure it out
Column A is a quantity, Column B is a price.  I have Column A and B
populated and want to make Column C to be the actual price paid (ie,
column a*column b).  Column A and column B, however, have about 2500

How can I create a link from a column in one worksheet to another cell in a
worksheet. More specifically I have  a column of dates and then a column of
values tied to those dates.  I want to link to the last value entered in that
column,  so as the last value gets added each day. ...

In Excel 2003, when using Find and Replace it cannot "find" anything. If I
just use Find and change the "Look in" to values it works, but when I cahnge
to Replace, the only option in "Look in" is Formulas!

I'm trying to get a number between and including 1 and 20
i have tried
=RAND()*(20-1)
thank you

I was trying to figure out why my phone bill tripled this month so I copied
and pasted the list of my alleged calls int an excel spreadsheet.  when I
tried to sum the column with the per call charges in it it is always zero.
ie. in cell h235 I enter "=sum(h4:h234)" without quotes. ...

I'm building a recruitment register and I've come up with a DIV/O!
error in a sumproduct formula where there is no division in the formula
- I have several sumproduct formulas and named ranges (all named ranges
are the same length) that work, except for this particular formula.