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