In one particular cell where I have a simple formula in C1
=A1-B1 where A1 is 2005 and B1 is 1 (both are text
formated) gives the right answer.

But the formula in cell C2 which is equal to =C1-B1
where C1 is 2005 in text BUT This time B1 is 01 in number
doesn't work. When I type this formula in C2, the answer
remains as =C1-B1 not an answer, but the string "=C1-B1"

Anyone understand why?