auto sum
 

I created a worksheet. When I use auto sum to total my rows & columns, the
formular can be seen but not the answer. What am I doing wrong. How can I get
it to show the answer of the auto sum?

auto sum
 

Press CTRL+SHIFT+~ to set the format of the cell to general number format

--
Kevin Backmann


"Bet Me" wrote:

I created a worksheet. When I use auto sum to total my rows & columns, the
formular can be seen but not the answer. What am I doing wrong. How can I get
it to show the answer of the auto sum?

auto sum
 

Maybe this the odd text format problem?. Check the cell format & make sure
it's not text. Then try selecting the cell and do edit replace with the
equal sign in both the find and replace box.
Evan Weiner Richland WA

"Bet Me" wrote:

I created a worksheet. When I use auto sum to total my rows & columns, the
formular can be seen but not the answer. What am I doing wrong. How can I get
it to show the answer of the auto sum?