All
When Paste Special links the option of Bitmap, etc is given instead of
linking the cell.  Also cannot just do = and select the other workbook and
select a cell.

a list of employee pay is being multiplied by the medicaid, ss and disability
rates to end with a net pay assuming no fed or state withholding.  the
formula for the net is the gross less the three calculated tax results.  the
result net pay is off by a penny in several cases ...

I am trying to make three conitional formats on a cell with text.
The cell text will be one of the following:
Di......
Do.....

For some reason, the copy tab function is not working for me.  I can move
Tabs, but when I highlight the tab(s) and select "copy", nothing happens.
Suggestions?
Thanks!

We get spreadsheets from another application that have a column of "numbers"
that act like text.  The only way to get them to act like numbers is to copy
them out to a text file and then copy them back in.  Is there an easier way?

I need to make a worksheet with a month worth of dates on it... One day for
each tab...is there any easy way to do this???

I'm currently using Excel 2002 SP3. I use conditional formatting in many
of my spreadsheets, but I haven't been able to figure out how to "Hide"
a row or column based on a certain condition. Is there a method for
doing this already built into Excel's functionality, and if not, is

I have a list of data and i need to reverse the order of the numbers..for
example
46183
29830

I need to color cells for instance if I have suppliers who are late on the
responses I need to color code a cell letting me know that the suppliers are
late and how late.  Can this be accomplished and if so how?
Miller

I've greated a one page spreadsheet in excel.  The format cells drop down
menu will not appear unless I am in an empty cell.  What have I done to cause
this?

I want to check to see if I get an error using VLOOKUP in visual basic.
If I do, I want something to happen; if not, skip over that step.
This is how I have it set up right now:
If IsError(Application.WorksheetFunction.VLookup(Cells(4, 5).Value,

Any help with Hypwelinks?

In Excel 2003, I have a spreadsheet with over 1500 rows that I would like to
insert a blank row everytime the category changes in one row.

I'm badly in need of some help with an excel formula. Essentially I
need to check to see if the value of C7 is "Y" and if so for the
formula then to look at D7 through to J7 and look for a value of "Yes".
the total amount of "Yes" boxes should then be multiplied by J5 and the

I have a list of about 2,000 social security numbers in excel. Some are
formatted with an apostrophe to preserve the first zero. I need them all to
be a string of nine numbers with no dashes and to preserve the first zero in
the formula bar. The Custom formatting dispays the zero ...