Re: Excel for Mac SR1 installed on MacBookPro won't automatically calculate

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Another posibility - check your "international" setting in "system
preferences", what is set as decimal point separator - but do not relly on
it.

I'm desperately longing for DOT as decimal point separator - all others
application will load setting from system pref. (the DOT) but NOT EXCEL -
still uses comma and then numbers with dots are asummend to be text rather
then numbers and excel will not calculate.
There's a know issue with language preferencences and office.


On 18.12.2006 9:09, in article
1166429376.685213.17070@xxxxxxxxxxxxxxxxxxxxxxxxxxx, "Ken Johnson"
<KenCJohnson@xxxxxxxxx> wrote:


Nick wrote:
I've just upgraded from a PowerBook G4 to a MacBookPro 2.33 GHz Intel
Core 2 Duo with 2GB 667 MHz DDR2 SDRAM. I installed Office:mac v.X on
the new computer. Excel spreadsheets won't calculate. I have verifies
that Preferences/Calculation is set to automatic, but formulas in cells
display as formulas, not values. Does anyone have any ideas how I can
correct this short of buying the newer version of Office for Mac OS X?

Thanks, Nick

Cells with the formulas formatted as Text is one possible cause.
Another is Preferences|View|Window Options...Formulas is ticked.

Ken Johnson



.

Relevant Pages

  • Re: How to set the default date format to D/M/Y?
    ... that menu open choose date the select the desired format. ... New document, format all cells of a column as Number, Custom, dd-mm-yyyy ... First observation, in previous versions of Excel the ... To obtain a date I have to type 4/13, disagreeing with the Preferences ...
    (microsoft.public.mac.office.excel)
  • Re: How to set the default date format to D/M/Y?
    ... go into preferences and try setting the date format to 1900. ... then go to Format menu and choose cells when that menu open choose date the select the desired format. ... First observation, in previous versions of Excel the formula shows as 28-04-2008 ...
    (microsoft.public.mac.office.excel)
  • Re: Date format not the same as settings
    ... I am trying to get excel 2004 to recognise my dates in the dd/mm/yyyy ... i have changed the settings in the preferences on the system to ... Select the cells in question, then go to Format> Cells. ...
    (microsoft.public.mac.office.excel)
  • Re: Anomaly? Office 2008 Remove Office failed to zap some old preferences
    ... MVP Bob "CyberTaz" Jones suggested in an Excel newsgroup discussion that my ... NOT remove your preferences because you might want them. ... to remove the below list of old preferences in this SUBfolder of my user ...
    (microsoft.public.mac.office)
  • Re: 39,330 = 9/5
    ... roger at technology4u dot co dot uk ... Roger Govier ... 39,000 number is trhe numeric value that excel uses for the date. ... the formating in the text changes the formating in excel. ...
    (microsoft.public.excel.misc)