Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default auto sum will not work

I am new.. I did the tutorials.. I have a new spread sheet and I can not get
the auto sum to work. I highlight my column and hit auto sum and it gives me
a formula but no total. I pushed enter but I can not figure this out. I'm a
dummy.
Please help me.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 15,768
Default auto sum will not work

Sounds like the cell if formatted as TEXT. Change the cells format to
GENERAL then hit function key F2 then hit Enter.

--
Biff
Microsoft Excel MVP


"Soshagayle" wrote in message
...
I am new.. I did the tutorials.. I have a new spread sheet and I can not
get
the auto sum to work. I highlight my column and hit auto sum and it gives
me
a formula but no total. I pushed enter but I can not figure this out.
I'm a
dummy.
Please help me.



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,276
Default auto sum will not work

Hi,
If you can see the formula but not the result, in excel 2007 go to Formulas
in the menu, then under formula auditing 3rd block, click on Show Formulas

"Soshagayle" wrote:

I am new.. I did the tutorials.. I have a new spread sheet and I can not get
the auto sum to work. I highlight my column and hit auto sum and it gives me
a formula but no total. I pushed enter but I can not figure this out. I'm a
dummy.
Please help me.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Sum doesnt work NAS Excel Discussion (Misc queries) 1 October 2nd 09 08:57 PM
Auto Filter Does Not Work Michelle Excel Discussion (Misc queries) 3 August 27th 08 05:34 PM
How do I get Auto-Fit to work correctly? Mickey Dunne Excel Worksheet Functions 0 May 11th 06 01:47 AM
Is there away to keep "auto save" from jumping to the first work sheet in the work book? Marc New Users to Excel 2 April 21st 05 01:27 AM
Auto-fill won't work spelunker64 Excel Worksheet Functions 1 November 16th 04 09:00 PM


All times are GMT +1. The time now is 08:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"