Hello,

The Text you have in the first two columns should not matter what the
format is. I think that the problem lies with the beginning format of
the cells that you are entering the formula in.

Start with formatting the cells where you are entering your formula as
general. Enter the formula. Drag down as needed. Then change the
formatting of those cells to Text if you want. It doesn't matter what
formula you type in a cell, if it is formatted as Text, all you will
get is the formula in Text. i.e. =A1+B1 will appear as is.

HTH

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=492297