I have a 6 digit number in a cell, say "980601" which is 1st June 98.
Can anyone help me get a formula/format that will conver this number to
the date format?
Thanks,

Hello all,
I have a simple problem which is turning wild for me. I need to count
the number of cells in a column with value 1. The range contains
formulas. Now when I give a countif of sumif or even count, it takes

i want to find the minimal number that's greater then a curtain number
i provide. all in a curtain array of numbers.
thanks
refael

This is a common subject for all the newsgroups
I raised this poiint earlier. somebody said tht the message would be too
long if there are too many threads for the same subject. But my problem is
suppose some subject in the newsgroup headers interests me and I click I get

I have a spreedsheet of data. Bsically it contains various products and  
various suppliers. The products are listed down the left side and the
suppliers along the top row. There is obviously more than one price per
product ie from each individual supplier. I have set up a basic ...

I would like to know if there is a way to save a file automatically
based on a name or value in a specifc cell on the worksheet.  For
example, cell B5 contains the value 22.  When I go to save can I have
it automatically save the file as 22.xls

I need to create a log that goes hand in hand with this contract that I have.
Both are in Excel.  The thing is I don't know if the following is possible
nor if it is how would I write the formula.  Here it is:
If in the contract the cell D6 says 11:00am, then I need the rest of ...

I have been trying to make sense out of how XL sorts my text. The help file
is clear on this ... and yet it sorts "[" before "1" (which is not the
stated default order).
So ... apart from special defined lists, is there an option to turn this

Bear with me - haven't been on newsgroups in a while.
Win 2003 XP
PC
Colleague is putting buttons (with macros) into a spreadsheet but would

I have a very large excel file.  When looking at a particular cell for
editing sometimes it's difficult to see that I'm in the correct row and
column.  Is there a way to make the active cell (column and row) accented by
color when editing it?

I'VE ACHANGEABLE NUMBER IIN a1 AND I PUT IN b1 "=MONTH(A1)
IN ORDER TO GIVE ME THE MONTH'S NAME WHEN I CHANGE THE NUMBER IN
A1 BUT IT DDINT WORK
WHY?

I have a spreadsheet with multiple customers who have multiple invoices.
Each invoices has several lines. I'm able to subtotal the invoices.
What I would like to do is show only the subtotal line but I would still
like to see the customer name. Is there any quick way to get the ...

hi, i am asking if you can, if so how the date flashes up in excel. in
example if u have a load of cars when there mots are due and you have
all the dates in, and i want it to flash up a colour(red) when it
reaches that date so you know when to mot it.

Hello, All!
If a workbook contains multiple worksheets, can worksheets be selected using the keyboard without clicking on the sheet tab using the mouse?
Thanks in advance!

howdy.
i have a column of numbers in excel and i want to add dollar signs in front
of them all.  There are 100 numbers in the column, can i do this without
adding the dollar signs manually?