I work in accounts recievables.  Some of the checks that I recieve are
$200,000.00, with hundereds of invoices referenced.  People never pay
invoices in line or by date, which make it very time consuming to post cash.
I was wondering if you can take a persons account with all the ...

I know this must be a really dumb question, but" what do you mean by :"by
default cells are locked"? Thanks

If we insert an auto shape in an Excel page whilst the macro recorder is on
the VBA codes will get written on the Visual Basic coding sheets. In 2003
version it happens. I am not able to do it in Excel 2007. Why?
Can an expert clarify this?

If we select an autoshape object in Excel 2003 for instance a rectangle on
sheet1 something like 'Activesheet.Shapes("Rectangle 6").Select will get
written on Visual Basic coding sheets. The problem to me is this code would
not work if that rectangle was replaced with an other ...

I have a single table in my xlsx file.
I would like to create a [static] html (.htm) file containing this
table.
Keep in mind that I don't want to save the workbook or worksheet as

I am trying to replace the values of a large range of cells with the value of
another cell (z5).  However it takes a long time to replace the information
given the size of the range. It seems to be updating each cell individually.
Any suggestions would be appreciated. Thanks. ...

I have a column of numbers, I want to format the numbers in a different
column using two different custom formats. Do i need an IF formula that will
Identify which number chooses which format if so what would it be .  
i.e

i want to add up staff hours for the week but when it gets to 24 it starts
from zero again like a 24 hour clock

Hi, I'm trying to do my first Chart. I would like to have the Y axis
divided as follows: 2,4,6,8,78.80.82.84.86,88.90.
The reason for this is that I am trying to plot 2 sources of data per
day. One will not go higher than 8 and the other source will fall

Hi, I have 2 problems
My first problem is that I have a large amount of data that I want to be
rounded to the nearest integer value.  What I have been using is
"=INT(ROUND(Q795,2-(1+INT(LOG10(ABS(Q795))))))" to get it to 2 significant

ou je suis

I receive PDF files from governemt and State agencies, like RFP's and RFI's
and most are LOCKED, so we cannot fill out the forms.
We have to make a copy and type information in.
Does Microsoft have an application to be able to overwrite or insert text

I have one spreadsheet that will not let me insert a cell or row and gives me
the error 'cannot shift objects off sheet'.  There are no objects and/or
comments on this sheet, so please don't refer me to the knowledge base
article - already tried that.  No hidden columns, cells, ...

After generating a column of numbers using the random number generator in
Excel, I  tried to sort the column low to high.  The sort appears to be
random and additional sorting only yields a random column of numbers.  How do
I fix the numbers for normal sort?

I need to read a email but I dont have excel. Ive got win XP home edtn, with
ms office and word but no excel. Is there any way that I can read the email
without having to buy excel as I cant afford it.
Cheers