+ Reply to Thread
Results 1 to 5 of 5

Currency Symbol to VLOOKUP Cell

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    346

    Currency Symbol to VLOOKUP Cell

    Hi,

    The enclosed sample excel sheet, G31 and G32 are Vlookup cells. NAV sheet is power query sheet.

    I would like add currency symbol English(Indian) to G31 and G32.

    How can I do this please.
    Attached Files Attached Files

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

    Re: Currency Symbol to VLOOKUP Cell

    You could use
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    but it would be better to edit your Query to change the 4th column to a numeric data type.

  3. #3
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    346

    Re: Currency Symbol to VLOOKUP Cell

    Not working

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Currency Symbol to VLOOKUP Cell

    Number format only applies to numbers.

    Power query need to change column to number

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    346

    Re: Currency Symbol to VLOOKUP Cell

    Bo_Ry Thank You

+ 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. Replies: 2
    Last Post: 09-26-2018, 03:19 PM
  2. [SOLVED] CONCATENATE and VLOOKUP - How to get currency symbol?
    By HayLinFa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-07-2016, 08:48 AM
  3. I want to extract symbol (format) of currency from each cell
    By Rajeshb938 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2016, 09:32 PM
  4. how to remove a currency symbol in a cell?
    By cat3appr in forum Excel General
    Replies: 6
    Last Post: 09-28-2014, 11:31 AM
  5. Change Currency Symbol on Worksheet based on cell value
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 36
    Last Post: 10-18-2013, 07:36 AM
  6. Currency conversion insert currency symbol
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-01-2013, 05:50 AM
  7. Replies: 3
    Last Post: 03-23-2005, 08:06 AM

Tags for this Thread

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