Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 1st 09, 01:06 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 75
Default Formula doesn't work unless hit enter again

I have to select Each cells with a function, than put my cursor in the
formula bar and press enter. The excel option 'automatic calculation' is on
and was always on before? Also, all cells are in 'numbers' format...not text.
Thanks !

  #2   Report Post  
Old July 1st 09, 01:59 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Formula doesn't work unless hit enter again

Try selecting all the cells
Edit|Replace
What: = (equal sign)
with: =
replace all

Maybe it'll wake up excel's calculation engine.

Bobby wrote:

I have to select Each cells with a function, than put my cursor in the
formula bar and press enter. The excel option 'automatic calculation' is on
and was always on before? Also, all cells are in 'numbers' format...not text.
Thanks !


--

Dave Peterson
  #3   Report Post  
Old July 1st 09, 07:06 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default Formula doesn't work unless hit enter again

Hi,

Show us an example of what you see in the cell before you hit enter and what
you see afterwards. Also show us a formula that is not working? Tell us
what you are changing that should cause the formula to recalculate, for
example, "I enter 5 in A1 and the formula still displays 34 and it should
show 39." Also, is this happening to all formulas in all workbooks, or only
in certain workbooks? Or does it only happen for a particular sheet in a
given workbook. Does the same behaviour occur when the file is opened on
another machine? What version of Excel are you using?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Bobby" wrote:

I have to select Each cells with a function, than put my cursor in the
formula bar and press enter. The excel option 'automatic calculation' is on
and was always on before? Also, all cells are in 'numbers' format...not text.
Thanks !

  #4   Report Post  
Old July 10th 09, 06:03 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 1
Default Formula doesn't work unless hit enter again

On Jun 30, 6:06*pm, Bobby wrote:
I have to select Each cells with a function, than put my cursor in the
formula bar and press enter. The excel option 'automatic calculation' is on
and was always on before? Also, all cells are in 'numbers' format...not text.
Thanks !


I am having the same problem and can't get it figured out. Please
help.
  #5   Report Post  
Old July 11th 09, 04:35 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Formula doesn't work unless hit enter again

If calculation mode is set to automatic and formulas don't update
then.................

You are working under the common misconception that if a number is formatted
to number then Excel will see it as a number.

You must coerce Excel into treating as a number.

Format all to number or general then copy an empty cell.

Select your range of "numbers" and editpaste specialaddokesc.

Now Excel will treat as numbers.


Gord Dibben MS Excel MVP


On Fri, 10 Jul 2009 10:03:37 -0700 (PDT), Steve Szczeck
wrote:

On Jun 30, 6:06*pm, Bobby wrote:
I have to select Each cells with a function, than put my cursor in the
formula bar and press enter. The excel option 'automatic calculation' is on
and was always on before? Also, all cells are in 'numbers' format...not text.
Thanks !


I am having the same problem and can't get it figured out. Please
help.




  #6   Report Post  
Old July 20th 16, 04:17 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2016
Posts: 1
Default Formula doesn't work unless hit enter again

This worked when I had the same problem. Not ideal but gets the job done. Thanks Dave.
  #7   Report Post  
Old September 29th 18, 03:56 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2018
Posts: 1
Default Formula doesn't work unless hit enter again

Just hit f9. It will fix it.

On Saturday, July 11, 2009 at 8:35:49 AM UTC-7, Gord Dibben wrote:
If calculation mode is set to automatic and formulas don't update
then.................

You are working under the common misconception that if a number is formatted
to number then Excel will see it as a number.

You must coerce Excel into treating as a number.

Format all to number or general then copy an empty cell.

Select your range of "numbers" and editpaste specialaddokesc.

Now Excel will treat as numbers.


Gord Dibben MS Excel MVP


On Fri, 10 Jul 2009 10:03:37 -0700 (PDT), Steve Szczeck
wrote:

On Jun 30, 6:06�pm, Bobby wrote:
I have to select Each cells with a function, than put my cursor in the
formula bar and press enter. The excel option 'automatic calculation' is on
and was always on before? Also, all cells are in 'numbers' format...not text.
Thanks !


I am having the same problem and can't get it figured out. Please
help.




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
Formula doesn't work unless hit enter again Whois Clinton Excel Discussion (Misc queries) 6 June 4th 10 05:06 PM
enter doesn't work with sumif Infrascanner Excel Worksheet Functions 1 January 27th 06 05:32 PM
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. qwopzxnm Excel Worksheet Functions 2 October 20th 05 09:06 PM
alt+enter does not work shazza Excel Worksheet Functions 5 September 23rd 05 08:25 AM
Excel, how do I get ALT F C to work the same as ALT F Enter C ? Rramirezn Excel Discussion (Misc queries) 2 July 21st 05 03:58 AM


All times are GMT +1. The time now is 03:36 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017