Yes, that could well be the case. I did notice the cell was formatted as
text, though I don't know why,
as there was a "formula" in the cell prior to the new fuction. It was simply
"=J6079".

Must be a new thing in Excel 2007.

Many thanks for your help

Cheers
Mark

"Niek Otten" wrote in message
...
Hi Mark,

This happens when the cell is formatted as text before you enter the
formula.
Formatting as General afterwards is not enough; you have to re-enter the
formula too (F2,ENTER).

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Mark" wrote in message
...
| Using Excel 2007 I'm having a new problem not faced in Excel 2003.
|
| Sometimes when I enter a function and press enter the function formula
shows
| but not the result.
|
| for example today it was =ADDRESS(L6079,4,1,1,$L$1)
|
| The result should be Sheet1!$D$6082
|
|
| But it was showing the formula =ADDRESS(L6079,4,1,1,$L$1)
|
| I pressed F9, Ctr/Shft/` (off on, off on), Hit F2, hit the fx button and
| checked the function - gave the result ok when the window was open.
Closed
| and opened the spreadsheet 2 times.
|
| Finally did get it to show the result now.
|
| But what caused it is a mystery. It's happened a few times now.
|
| Any clues?
|
| Cheers
| Mark
|
|