+ Reply to Thread
Results 1 to 6 of 6

Currency as text with currency suffix

  1. #1
    Registered User
    Join Date
    02-04-2021
    Location
    Csatar
    MS-Off Ver
    MS Office 2019
    Posts
    22

    Currency as text with currency suffix

    Hello i would like to insert Currency value to cell as text and just convert it to real currency format like 125.00 HUF with the following format:
    Please Login or Register  to view this content.
    So the text inserted value is same as format code output, but it cannot appliy while the " HUF" suffix is given, but if i delete from the end of string it work perfect: same as text.

    So somehow i need to force exel to interpret the Currency value and suffix without i cut down the suffix manualy.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Currency as text with currency suffix

    One way:

    =SUBSTITUTE(SUBSTITUTE(A1,"HUF","")," ","")+0

    copied down. Format as 0.00 "HUF"

    In H you may need ; instead of ,
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    02-04-2021
    Location
    Csatar
    MS-Off Ver
    MS Office 2019
    Posts
    22

    Re: Currency as text with currency suffix

    Thank you for solution! The H version it automaticaly convert function to local's and , to ; if i open the docs you attach. H version func is : "helyette"

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Currency as text with currency suffix

    Szívesen!

    and thanks for the rep.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Currency as text with currency suffix

    In response to your PM:

    # ##0.00\ [$HUF];-# ##0.00\ [$HUF]

    Red: How to format positive numbers
    Black: How to format negative numbers

    ie to 2 dps, preceeded by a - if negative with the currency unit HUF.

  6. #6
    Registered User
    Join Date
    02-04-2021
    Location
    Csatar
    MS-Off Ver
    MS Office 2019
    Posts
    22

    Re: Currency as text with currency suffix

    AMD this:
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by pozso123; 02-04-2021 at 08:29 PM.

+ 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] Change currency in quotation (automatically if an certain currency is selected.
    By The excel apprentice in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-29-2021, 03:31 AM
  2. How to convert the currency and then sum up into single currency
    By cresender in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-03-2021, 10:48 AM
  3. Replies: 2
    Last Post: 09-26-2018, 03:19 PM
  4. [SOLVED] Formula that contains currency not returning the results as currency
    By Triscia in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 07-17-2014, 03:02 PM
  5. Currency conversion insert currency symbol
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-01-2013, 05:50 AM
  6. Replies: 5
    Last Post: 06-30-2011, 07:48 AM
  7. Currency Formatting-range of number as currency
    By kmurray24 in forum Excel General
    Replies: 1
    Last Post: 01-09-2008, 09:09 AM

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