After you reformat the cell as General (or Number--just not Text)...

select the cell
Hit F2 (to edit the cell)
Hit Enter

Excel will recognize it as a formula.

richjthorpe wrote:
>
> It doesn't seem to make a difference.
>
> --
> richjthorpe
> ------------------------------------------------------------------------
> richjthorpe's Profile: http://www.excelforum.com/member.php...o&userid=33352
> View this thread: http://www.excelforum.com/showthread...hreadid=531842

--

Dave Peterson