+ Reply to Thread
Results 1 to 2 of 2

INDIRECT and convert cell name to number?

  1. #1
    Registered User
    Join Date
    04-16-2019
    Location
    Sleaford
    MS-Off Ver
    O365
    Posts
    78

    INDIRECT and convert cell name to number?

    Hi all,
    I'm facing an issue with INDIRECT function. I'm using it to display pictures depending on the cell value.

    Rename A1 and A2 cell as cellone and celltwo
    Then i insert 2 pictures for each cell
    in C3 cell made a new value cellone
    I did Define Name set up in formulas tab. Then wrote down name as PICTURES.
    =INDIRECT(PICTURES!$B$2)

    Then i insert one more picture and add a formula to it =PICTURES

    Everything works fine. It displays picture depending on C3 value.

    However i require that cell A1 and A2 would be a number example 251-5447 and excel doesn't allow it to do.

    Is there a chance to change cell name to number?

    Attached sample file..

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,068

    Re: INDIRECT and convert cell name to number?

    You could name the cells like
    _251.5447

    and then use
    =INDIRECT("_"&SUBSTITUTE(Sheet1!$C$3,"-","."))
    for pictures
    You can then enter 251-5447 into c3

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to convert a number to a cell name?
    By RustyNail in forum Excel General
    Replies: 10
    Last Post: 02-20-2018, 11:48 AM
  2. [SOLVED] convert cell to number
    By mma3824 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2014, 12:27 PM
  3. [SOLVED] convert a percentage cell to a normal number in another cell
    By tlacloche in forum Excel General
    Replies: 4
    Last Post: 09-26-2013, 09:28 PM
  4. [SOLVED] Convert cell to number
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-25-2013, 06:14 AM
  5. Replies: 2
    Last Post: 10-27-2011, 05:30 AM
  6. convert a letter to number in different cell
    By Game Time in forum Excel General
    Replies: 3
    Last Post: 10-22-2009, 04:29 PM
  7. Convert Number to Text in cell
    By fvlmasl2 in forum Excel General
    Replies: 1
    Last Post: 05-12-2005, 01:52 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1