paste won't paste

[Harvey Waxman]

I have this formula:

=IF(J4="","",DAYS360(K2,J4,3)) which gives the day of the year
corresponding to the date entered in J4
(in K2 is 38351)

Works fine.

If I copy the formula to another cell, it appears as text including the
equal sign.

If I change the original to this, so the copy/paste will be independent
of location, like this:
=IF($J$4="","",DAYS360($K$2,$J$4,3))

the cell shows this text: =IF($J$4="","",DAYS360($K$2,$J$4,3))

I can't even type the formula anymore and get the correct number to
display, just text.

What's going on?

OSX Leopard

 

[CyberTaz]

Is the cell you're pasting to formatted as TEXT? Change the format to
GENERAL.

 

[Harvey Waxman]

Is the cell you're pasting to formatted as TEXT? Change the format to
GENERAL.

Did that first.

Since I wrote, I restarted Excel. Problem went away. We'll never know.
It was almost funny to see.

Thanks