It should not matter. It is important to compare the formula bar to what you
see in the cell. If you see the formula in both places, then Excel thinks
that for some reason the contents are text.

Perhaps you have leading or trailing blanks in the cell along with the
formula.
--
Gary''s Student


"left_blank" wrote:


Thanks for your help, but it still did not seem to work, would it have
anything to do with me importing from a notepad file?


--
left_blank
------------------------------------------------------------------------
left_blank's Profile: http://www.excelforum.com/member.php...o&userid=34181
View this thread: http://www.excelforum.com/showthread...hreadid=539437