But making a change (or pretending to make a change via F2, then enter) is very
important.

Just changing the format of the cell from Text to General isn't enough to alter
the value in the cell.

David Biddulph wrote:

The significant bit isn't the F2 as such; the important bit is changing the
cell format to anything but Text. F2 merely puts you in edit mode to let
you enter the formula again after you've got the cell format right.
--
David Biddulph

"Victor Delta" wrote in message
...
"Dave Peterson" wrote in message
...
If you're seeing the formula in just a few cells, try:

Select the cell
format it as general (or anything but text)
Hit F2 and then enter.

If you have lots of cells, select the range of offending cells
Format them all as General (or anything but text)
edit|replace
what: = (equal sign)
with: =
replace all

Biff and Dave

Many thanks - you are stars! Your suggestions sorted the problem pronto!

Although, having never had this problem before, I'd be interested to know
what I did wrong this time and how your F2 solution works.

Thanks again,

V

--

Dave Peterson