Kitz ADSL Broadband Information
adsl spacer  
Support this site
Home Broadband ISPs Tech Routers Wiki Forum
 
     
   Compare ISP   Rate your ISP
   Glossary   Glossary
 
Please login or register.

Login with username, password and session length
Advanced search  

News:

Author Topic: Excel problem  (Read 3682 times)

renluop

  • Kitizen
  • ****
  • Posts: 3173
Excel problem
« 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!
Logged

SecTSys

  • Member
  • **
  • Posts: 84
  • I only work with HTCPCP
    • Putney Computers Facebook page
Re: Excel problem
« Reply #1 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
Logged
Visit the Live Gaming Website STSLG Website
Visit my YouTube gaming channel at STS Live Gaming

renluop

  • Kitizen
  • ****
  • Posts: 3173
Re: Excel problem
« Reply #2 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
Logged

SecTSys

  • Member
  • **
  • Posts: 84
  • I only work with HTCPCP
    • Putney Computers Facebook page
Re: Excel problem
« Reply #3 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
Logged
Visit the Live Gaming Website STSLG Website
Visit my YouTube gaming channel at STS Live Gaming

renluop

  • Kitizen
  • ****
  • Posts: 3173
Re: Excel problem
« Reply #4 on: October 09, 2012, 07:38:27 PM »

Seems it was the macro settings, now completely disabled!

Thanks guys :drink:
Logged

bbnovice

  • Reg Member
  • ***
  • Posts: 215
Re: Excel problem
« Reply #5 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
Logged

renluop

  • Kitizen
  • ****
  • Posts: 3173
Re: Excel problem
« Reply #6 on: October 11, 2012, 03:21:50 PM »

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

SecTSys

  • Member
  • **
  • Posts: 84
  • I only work with HTCPCP
    • Putney Computers Facebook page
Re: Excel problem
« Reply #7 on: October 12, 2012, 03:59:34 PM »

Sweet glad that one got sorted out :D
Logged
Visit the Live Gaming Website STSLG Website
Visit my YouTube gaming channel at STS Live Gaming