I was wondering if there's somehow I can fill n char width cells with
spaces.
i.e. If I have a blank cell with width "8", it will be filled with 8
spaces. It'd be something like format cells with "00000000", but with

I use the same worksheet month after month, however when I create a new month
sheet and copy and paste last months to it, I either have to paste All or
just formats, formulas or ...  I have to manually delete All the text (and
sometimes there is Lots)

I need calculated values to be displayed without any trailing zeros.  For
example:
if the result is 12.0, I need it displayed as 12
if the result is 5.50, I need it displayed as 5.5

The Scanjet 4850 has an IRIS OCR which does not recognizes Excel. Can I use
another scan programme with the HP Scanjet 4850 or is there a way to bypass
this problem
Thanks in advance for any assistance

Hi...I need some help.
I have a drop down list on my spreadsheet.  The values within the cell
for the drop down list are populated by a vlookup depending on what i
typed in cell A1.  I need whatever is selected from the dropdown lis

I'm trying to populate a new worksheet by flagging cells in a previous
worksheet. Specifically, populate the first column of worksheet named
BestBall using this logic:
If Entry!F4:F154 = "bb1", then grab value of column A and display in first

I need help with a macro.
I have 5 columns and 75 rows that need a Vlookup function in them.
Each column will be using a different sheet for the Vlookup and eac
row will need a differnent column # to retrieve the data.  Is there

I have 2 sheets in one workbook.
1st sheet - March 18, contains:
#    #          # OF ACCTS
1    5              10

Why can't I use nonadjacent selections as a range in the =COUNTIF formula?
For example: =COUNTIF(FirstGroup,E53)
  where FirstGroup is a nonadjacent selection of cells A10:A20 G10:G20

Recently I used the amortization schedule designed by Microsoft. It's
fantastic. However, it will be more friendly and convenient for the users if
at the end of each year the user can see a subtotal for the interest paid,
principal paid, etc.

I want to be able to check two cells at once to see if they contain a number
and then do a calculation based on whether they do or don't. The problem is
the ISNUMBER function does not seem to be able to check two cells at once.
Is there any way around this?

My data table is like so:
Date    Type    ID    Status    GiveUp    Name    Count
20060314    Order    BOX017        226    Q0    2
20060314    OrderO    BOX017    Directed    226    Q0    3

Please review following formula,
=IF(AD2="B10x5x5",VLOOKUP(AP2,B10X5X5,2),IF(AD2="B10x10x5",
VLOOKUP(AP2,B10X10X5,2),"Your Choice"))
Depends on cell AD2, if is "B10x5x5" then Vlookup use table B10X5X5, or if

I have the following fields in a spreadsheet:
Order Number
Product A
Product B

I am updating a pivot table with data from a worksheet.  All the fields
update correctly except the "spend" field which contains numbers - the field
I am updating displays "0.00" even though there are numbers in the original
worksheet where I collected the data from.  The data ...