+ Reply to Thread
Results 1 to 7 of 7

Currency conversion insert currency symbol

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    227

    Re: Currency conversion insert currency symbol

    can anyone help me on this?

  2. #2
    Forum Contributor
    Join Date
    04-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    227

    Re: Currency conversion insert currency symbol

    anyone please

  3. #3
    Registered User
    Join Date
    01-28-2013
    Location
    Coventry
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: Currency conversion insert currency symbol

    Like yudlugar said try

    Textbox1.Value = "$" & Textbox1.Value
    But know that because the symbol ($) is part of the string, it cannot be used in a formula.

    You could try not using the $ sign at all, and set up a table with a $ as a column header. That way you use text for labels only and numbers for values only.

  4. #4
    Registered User
    Join Date
    01-28-2013
    Location
    Coventry
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: Currency conversion insert currency symbol

    another thought, set up a label on your userform, place it next to the USD textbox. In this Label, change the settings so that it shows $ symbol, and change colour setting so it matches your background

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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