Hi guys, probably basic question but, this is what I need.
I have 50 rows of a date in Column A, for example, 1/1.
I need 50 rows of each day in the year, so 50 rows of 1/2, 50 rows
below that of 1/3.  What formula would I use to pull this off?

anyone know how to make a '+' sign show up in front of a positive
number?
also, if there is no 'clean' way to do it, how do you concatenate a
text string with an equation (i.e., something like '=A1+A12')

Is there anyway of changing the format of the date automatically that has
been downloaded. I have tried everything.
For example, in the main column is DATE, and is in the format 05/18/2000.
(18th May 2000)

Is there a way to put an Excel spreadsheet on my website and allow others to
actually input data into that sheet?
If so, a nudge in the right direction would be appreciated.
Thanks

Hope someone can help.  When I startup Excel it comes up in PERSONAL.XLS
instead of Book 1.  Also, when I enter data and then save my work as a
different name, the next time I open that file it comes up  as PERSONAL.XLS
again and gives me the choice of 'Disable Macros', 'Enable ...

I am using Excel 2000, but I am pretty sure I have observed this
behaviour before in other versions:
How can you paste a table of values into Excel without the program
interpreting the values as anything except text? Here is a good example

Has anyone seen this error message before when trying to hide columns?
"Cannot shift objects off sheet."

In order to save time it would be useful to create a cell reference that
contained a variable.  Does anyone know if this can be done and if so what
the notation might be?
The idea is this:

I am generally familiar with Excel, but need some help on this particular
problem.
Is there a way to apply a format where:  whenever the number in a column
differs from the one previous to it, a cell shading color change is applied.

I've been using drop down list boxes in an excel 2003 worksheet.  In 2003, I
am
able to lock the cell with the drop down box and protect the worksheet, which
then prevents anyone from selecting a new value from the drop down boxes and

Trying to move this formula from the sheet formula to a VBA function,
because using the sheet formula, the formula is lost after being used
once, incase the user changes their mind and they go back...
=IF(E4="N/A", 0, "")

Several days ago I posted a problem using VBA for Office 2003 and Excel
2003.
The basic problem was this:
   Under Office 2003 Professional Edition with SP1, if I open the VBA

Är det någon som vet hur man gör för att räkna om en fem minuters period i
0,083?

I am trying to write a macro to add "=+" to the contents of a cell.
Cell A1 contains AD11 and I need it to say =+AD11
Cell A2 contains BC34 and I need it to say =+BC34
(I have a couple of 1000 cells to add this to.)

I saw some other post about kind of the same problem but not this way.
I have a risk evaluation formula in a cell. Output range is between 1 and 9
If between 1 and 3, I want to assign the color lightgreen to it
If between 4 and 6 I want to assign the color yellow to it