Cell format switches to TEXT

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Whenever I edit a cell it changes format to TEXT. Then I have to set
the cell format back to GENERAL, type a CR in the formula bar, and then
I see my calculations. This is only happening in one workbook so
there's something fishy about it's properties. Is there a default cell
format type?

~Bob M.
 
My bet is that your formula points at a cell that's formatted as text.

If you put today's date in A1 (ctrl-semicolon will do it)
then put =a1
in B1

You'll see that B1 inherited A1's format.

Same type of thing happens with Text cells.

I don't think you can do anything except continue to change it back.
 
Back
Top