+ Reply to Thread
Results 1 to 13 of 13

How to convert a column number into another column cell

Hybrid View

  1. 12-27-2013, 03:49 AM #1
    Max, Singapore
    Max, Singapore is offline
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520

    Re: How to convert a column number into another column cell

    It may be the Excel version you are using ?
    Try changing the comma in the formula to a semi colon, viz: =INDEX(A:A;ROW()*2)
    My excel uses commas as separators
    Last edited by Max, Singapore; 12-27-2013 at 03:52 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to convert cell to text and ensuring 7 digit number all along in entire column.
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-19-2013, 09:35 AM
  2. how to extract column letter of a cell & select cell by referencing its column number
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-12-2010, 08:55 AM
  3. convert column number to column letter
    By ilkamalo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2009, 04:35 AM
  4. Convert column number to letter
    By gtmeloney in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2009, 11:13 AM
  5. Convert a column into a number of rows
    By ArranMoffat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2005, 12:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1