I am writing reference ranges in columns for lab tests and am having a
problem. In the column i want to write: 10 - 20, but everytime i change to
another column it changes to Oct 20. This is getting on my nerves. What do i
do to prevent this?

I posted this about a year ago, received a reply that may have
involved a registry fix, successfully implemented the fix, and, since
it was no longer a problem, promptly neglected to save the
information.  Now, after some reloaded software, the problem has

    My boss is very interested in getting the most out of excel, we use it
quite a lot and are always looking for new ways to save time and effort.  We
have desided that Macros and VBA are worth investigating further.  There has
been some talk of sending a co worker and I to ...

in excell how do I take a number from the same cell in multiple sheets and
then take an average?

I am using the Excel Random Number Generator in a Monte Carlo simulation.  
When I open a separate very large file and do a copy/paste from the Monte
Carlo into the separate file, the random number generator seems to have a
distinct upward bias (from the time of the copy/paste ...

I would like to count and determine the most often (10) occurent
values (strings) in a column.
How can I do that?
Thank you very much your help.

I have a worksheet with 2 Sections - Open Tasks and Completed tasks.
I want to create a forumula that checks a cell for the text "Completed" -
once completed I want the whole ROW cut and pasted into the Lower section of
the same Worksheet.

I have a string that looks like this:
"5,789.93 YTL / 4,123.88 USD / 3,124.11 EUR"
The string's length and the numbers it contains will vary from day to day
and the numbers will not always have the same number of digits. (The last

I have been given a pivot table that already had six years of data in
it, and was told to add four more years data to it.   I went into the
source document and added everything that needed to be added in the
correct places, and then refreshed the pivot table.  The pivot table

Trying to use conditional formating to change the font to red of any
cell that exceeds the cutout point.
Example
Column A:

I've got some constants and such in the far right-most columns, where
my average user wouldn't have any need of going.  Just to add an extra
measure of safety, though, I wanted to either hide the columns or set
the column width to something like 0.1.  Excel won't let me do either

I am trying to set the conditional formatting on cell C21 so that if
the value in cell IS21 is less than 2 the cell changes color.  Then I
want to copy this down column C so it evaluates across each row.
I tried using FormulaIs IS21<2, but (a) it didn't change color, and

I have a spreadsheet where I track amounts owed to subcontractors and
when they were paid.  I'm trying to create another tab where I pull
all rows that have not been paid.  The only thing anyone has suggested
so far is autofilter but that isn't what I'm looking for. Is there a

I know this has to be pretty simple but I can't quite figure it out. I
want a field at the end of each row which will count the number of
fields with a "Y" and show the total number. I tried an IF statement
but this went all wrong and I have tried the COUNT () statement but

I wrote a vba macro to match cells in range 1 with range 2. I uses 4 input
boxes to collect from end users information like range 1 say A1:B11, range 2
say C1:H65536, first cell in range say A1, and lastly first cell in range 2
say C1. After that, i uses a function (=countif(.... ...