Kitz Forum

Computer Software => General software => Topic started by: renluop on October 08, 2012, 05:48:05 PM

Title: Excel problem
Post by: renluop on October 08, 2012, 05:48:05 PM

Instead of cell references being alpha-numeric, they have changed to numero-numeric.

I have no idea how they got changed, nor how to get them back to normal.

Help please!

Title: Re: Excel problem
Post by: SecTSys on October 08, 2012, 06:25:39 PM

this can be changed in your cell formatting preferences in excel.

for the most part the options will be under edit - preferences, (2007) or the office button and options in 2010 / 2013 versions

Title: Re: Excel problem
Post by: renluop on October 08, 2012, 06:37:56 PM

I'll look at that! Thanks! :)  BTW this is the sort of thing I'm getting  in cell N3

=+RC[-4]*2*RC[-3]+179

Title: Re: Excel problem
Post by: SecTSys on October 09, 2012, 04:39:56 AM

Not sure about that - but from what i have looked at it looks like you have macros on the spreadsheet document there. or that seems to be the most common theme from a google search anyway. - If cell formatting isn't the answer - try turning off Macros see if that changes anything.

I did find this - though you might have to read through it a bit to find the related bits of information about half way down the page.

http://excel.bigresource.com/Convert-Formula-to-RC-Notation-j4rhHBWl.html

Title: Re: Excel problem
Post by: renluop on October 09, 2012, 07:38:27 PM

Seems it was the macro settings, now completely disabled!

Thanks guys :drink:

Title: Re: Excel problem
Post by: bbnovice on October 09, 2012, 07:53:47 PM

I'm puzzled by your comment about macros.

Simply, the R1C1 style referencing in EXCEL became switched on for some reason.

You can turn this on/off using the options in EXCEL. Each EXCEL version puts this somewhere different in the menus, but for EXCEL 2007 for example you do the following:

Excel Options 

Formulas  - make sure that there is no tick in the box called:-

    R1C1 reference style

Title: Re: Excel problem
Post by: renluop on October 11, 2012, 03:21:50 PM

Puzzle not dear friend" My comment arose out of the post by SecTSys.

Title: Re: Excel problem
Post by: SecTSys on October 12, 2012, 03:59:34 PM

Sweet glad that one got sorted out :D