My excel worksheet options are set to display 0.41200 (5 decimal places).  
How can I keep this formatting when I save as a csv file? (I keep losing the
zeros).

When using the VLOOKUP or CONCATENATE functions, after entering all the
necessary parameters, the result of the function is the function equation
itself.  For instance, here is what my VLOOKUP function is returning for a
value :=VLOOKUP(C2,'[Material Class BO Download ...

Heres my formula         =IF(B2=0,0,'1'!$P$31)  1 is worksheet 1, I have 310
worksheets and a total sheet, How can I copy this formula down to show
worksheet 2 then 3?  thanks alot

Adding several cells and then subtracting several cell from that total, and
showing the result in another cell?

Is there possible to hyperlink to a certain sheet in another document?

We are creating a overtime sheet in excel that if someone enters the time
from and to it will cacularwe ir It calculates it into minutes but we want to
round off to the nearest quarter hour and also to show by quarter of hours
only

I'm trying to count the unique values given several conditions, for example
in the example below, count the number of unique Item_num's that were sold on
Wed during the Morning, which would return 2:
          A              B            C

My problem is:
I like to sum all the numbers in a column exept the last post... Th
problem is that I will be adding numbers so the column will becom
longer and longer but its always the last post dont want to add to th

I have a large spreadsheet with 12 columns and 2400 rows.  I use a filter to
bring up one account that shows me sales for each month, each month is on a
separate row so the filtered results have twelve rows of data.  I then
subtotal the results which add up the twelve months of ...

we have a invoice spreadsheet which gets firgures fron a another spreadsheet
& makes invoice for ex:
invoice column 1= Quantity
invoice column 2= Descriptition

Let's try this again!
This is what I want to do.
I want a cell to put the following
If E2 (contains the invoice amount)  is between $0 and $50  put "$0 -

I need to creat a formula that will show the sum of three cells, minus the
totals of three other cells? Please help

I'm creating a timesheet and running into some trouble calculating total time
usage.
Here's the setup:
I have a column P in which conditional data is entered (e.g., if a person

Is there any quick way to display a list of numbers in thousands? for
instance, how to change the display of 10,000 into 10 other than put in a
formula of 10,000/1000?
Thanks a lot!

we have a spreadsheet that has columns for customer charges and totaling the
charges from all columns and have a paid column for partial or full payment
and then having a balance column we would like to clear old history
Is there anyway to clear every 2 months automatically all ...