I have a spreadsheet with B9:B39 containing the numbers 1 to 31, B4 =  a
month and B5 =  a Year.
The month and year cells are validated so the user chooses "April" etc from
a drop down list and likewise "2008" from a dropdown list in the year cell.

Let's say I have a text called "Text" in column A1:A3.
In column B1:B3 I have a formula counting number of
square foot. In colum C1:C3 I want to output the text
in column A combined with the output of column C.

Hi! I want to use the PARETOINV function in Excel 2007.
But there is no description on how to enter the parameters
or which parameters to use between the brackets.
PARETOINV()

need for projected csah flow report.thanks

I'm looking for a formula that can calculate the sum of a number of
rows given. In the example below the formula should output the sum of
the figures from the last 7 rows (starting from the right to the
left).

I created a pivot table but the end result has many empty blanks and
unecessary totals, please does anyone know how I can sort and or filter the
columns without messing up my data. I need just clean rows and of data
without the spaces and the total. I have 20 columns and ...

I have the language set on Eglish (Australian) but trying to format cells to
show date as 08-May -2008 for example.
NormallyI would type 08/5/08 and it would formated as above. But now if I
type that in it thinks I have typed month in first - like US mehtod. How can

I need to find the smallest number in a column which may have the
range from 0 to 9 but need to exclude 0 ie: strokes in a game of golf
so that I can calculate the lowest number of strokes taken. Zere means
that they have wiped the hole and therefore cannot be used.

Microsoft 2003 - I have to compare data extracted from one application to
data extracted from another application and resolve all discrpancies between
the two files.  Any ideas on how to do this?
The file has 8 columns - 4 from one application and 4 from the other

(Newcomer please be gentle!)
I am trying to set up a monthly time sheet spreadsheet for an organisation
that has staff working 7x24.
Ideally I should like the spreadsheet to automatically assign the date and

I've recently created a spreadsheet which contains a date formatted to show
as the day of the week by means of "dddd".
However this spreadsheet is to be used in Germany and France and I've
discovered that in order for the formatting to work, "dddd" has to be

i don't know vb.is there any formula or function in excel 2007 to do the
following convertion.
number "100" convert in to text"hundred"

I need help.  i have a worksheet that is set up in columns like:
id    acct no    amount  
I have 250 rows of data and a lots of columns
Whiat I would like to do is set it up so that the rows look like this

I have a sheet which have dozen of cells and rows but i want that
someone who ever is using that workbook that could move only on
limited cells e.g. only on C3, C15, C48 and E55 the user can edit as
well and if a user try to click on any other cell cursor or mouse will

I need to find a template for wage/pay slips, can anyone give me any advice
on where to find these.