hi we have a simple formula to work out employees pay (hourly rate x hours
worked = gross amount) however currently exel is not recognising a 6 as a 6
in the final total eg 520.16 +520.10 should  = 1040.26 however it is showing
1040.15

How to limit the number of columns on a sheet? I'd like to have a
columns on a sheet and afterwards coming the "gray area" (Like it i
coming after 256 columns or 65536 rows)
Thanks in advance

My full problem is that I have a couple txt files that I need to work
with in Excel, however druning the import I can't get a custom format
for a column.  Because of this I have to import a column that should
always be a 4 digit class code as text, I would then like to reformat

If I am using input boxes to enter data into a worksheet, is it also
possible to have data validation on the cell?
Thanks
J

I have two sets of data (2 worksheets)
one set contains a column with 14000 different numbers and a second column
with corresponding values to these numbers.
the second worksheet contains a column of numbers which are some (7000) of

Hello all!!im filling a dropdown list with results from a query as th
code shows (i fill the drop down everytime i open the xls file), BU
this dropdown keeps all information when i close the file and when
run the code again the result is merged into the older, i need to clea

I'm sure there is a simple explanation but I can't come up with it.  The
following is the formula I am using:
=IF(OR(X2="roll not cut",X2="cut not roll"),"OK to process", " ")
Basically, I am using this with a spreadsheet I receive from another user.  

I have 12 worksheets of certain data, that is one worksheet for every month
of the year (i.e. Jan-Dec). In each worksheet/month I have already calculated
the
following functions/formulae:

I have a data base as below giving datewise requirement of parts
Part    01.07.06        02.07.06        03.07.06
A    50                              50
B                          70        10

Ok, basically I want to do a lookup to return some figures...  I know
all the VLOOKUP, etc...  trouble is I don't just want to return one
figure.  It may be 1 figure but then it may be about 9/10 as well.
I've got a list of order numbers and a list of orders that need an

Hey there,

I am currently working on a project which required me to do a project
using macro. I have to create a macro which enables me to join up two

I have a price sheet and would like to add 10% to the entire column,
how is that done? Any tips to were to look.
Thanks
Dennis

I'm getting stuck...
If I enter some new data in Sheet2, column A, then this cell will be copied
to last cell of sheet 1 columnA automatically. This task can be done now
IF the  data is overwriting some existing data, no need to copy.

I have a number of Excel files on a network server which it is mapped on my
PC as the 'H' drive, however for some users this drive is mapped as their
'K' drive. I have created links to various Access databases for which they
auto update when I open the Excel spreadsheets. However ...

I have a macro that will format project files based on their projec
number. in order to record the prject number. I have created a form fo
the user to enter the project number. My problem is entering a comman
line to open the form once the user selects which type of project fil