Using formula =a1-b1 The cell only displays the formula - - not the answer.
A Allllen Oct 31, 2006 #2 click on that cell do format > cells on the number tab (the first one), click category: general, OK (you will probably see it was formatted as text) then double click back into your cell, and press return.
click on that cell do format > cells on the number tab (the first one), click category: general, OK (you will probably see it was formatted as text) then double click back into your cell, and press return.
J jrivel Oct 31, 2006 #3 Perfect - - Thanks very much. Allllen said: click on that cell do format > cells on the number tab (the first one), click category: general, OK (you will probably see it was formatted as text) then double click back into your cell, and press return. Click to expand...
Perfect - - Thanks very much. Allllen said: click on that cell do format > cells on the number tab (the first one), click category: general, OK (you will probably see it was formatted as text) then double click back into your cell, and press return. Click to expand...
