Re: Excel formula showing jumbled characters
 From: mac_convert_in_tn@xxxxxxxxxxxxxxxx
 Date: Wed, 2 Jul 2008 17:13:49 0800
Thank you! Not sure how it got there, but that was the issue. Appreciate the help.
Sounds like you are in R1C1 mode, if you go to Excel\Preferences\General and.
check off 'Use R1C1 Reference Style' you should see your formulas to appear
as you'd expect them to.
Thanks!
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided �AS IS� with no warranties, and confers no rights.
On 7/2/08 3:27 PM, in article 59b530f2.1@xxxxxxxxxxxxxxxxxxxxxxx,
"mac_convert_in_tn@xxxxxxxxxxxxxxxx"
wrote:
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
Excel 2008 has been working fine for me until yesterday. I'm an advanced user
of Excel but cannot figure out how to remedy the following (or what I may have
done to cause it).
Normally in the formula bar when you enter a formula it shows something like
=A2/A3 However, now my computer shows undecipherable R and C followed by not
the row or column number as one would expect. It shows, for instance the
following: =R[1]C[1]/RC[1] (this is an actual formula that shows up when I
select cells to make the =A2/A3 formula. Can someone help me resolve this?
Thank you very much. (PS I have gone to preference and looked at the options
and unlike in Office for Windows where there is tools>options the mac
preferences seem to be more limited/black and white... unless I'm missing
something).
 References:
 Excel formula showing jumbled characters
 From: mac_convert_in_tn
 Excel formula showing jumbled characters
 Prev by Date: Re: PROBLEM SAVING EXCEL DOCS AFTER 11.5.0 UPDATE
 Next by Date: how to make a check box
 Previous by thread: Re: Excel formula showing jumbled characters
 Next by thread: Re: PROBLEM SAVING EXCEL DOCS AFTER 11.5.0 UPDATE
 Index(es):
Relevant Pages
