I am trying to sum a column of numbers. Unfortunately the formula shows up
instead of the actual sum. Please help!
I am trying to sum a column of numbers. Unfortunately the formula shows up
instead of the actual sum. Please help!
Check the formatting. It sounds like you have formatted it as text. If it
is, change it to number format, or general. You might have to edit the
formul for the formatting to take effect (highlight the cell, hit F2, and
then enter).
"Linda" wrote:
> I am trying to sum a column of numbers. Unfortunately the formula shows up
> instead of the actual sum. Please help!
Select Tools>Options and make sure that Formulas is unchecked in the Windows
Options section on the View tab
"Linda" wrote:
> I am trying to sum a column of numbers. Unfortunately the formula shows up
> instead of the actual sum. Please help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks