When I go to a cell a type the formula: = 2^12*B15 , it reports a
#VALUE error. B15 is a text value.

When I look at my friend's workbook, he has written the same formula
and it reports 0. How can I do this? I have checked my number formats
and changed it to special but still it is not solving the problem.

How can I solve this problem?

Thanks in advance.

Swamy