+ Reply to Thread
Results 1 to 3 of 3

Formula returning comma after $ sign

  1. #1
    Registered User
    Join Date
    03-23-2016
    Location
    Belgrade, Serbia
    MS-Off Ver
    2013
    Posts
    7

    Formula returning comma after $ sign

    Hi Guys,

    Hope someone can help me with the problem here. I have a formula which is supposed to return a textual form like this:

    30.09.2016. SEPTEMBER CLOSED. REV 3,225 X $,0.08 = $,258.00 | COST 3,185 X various = $,168.35 | PP = 35% | Completed 103%

    As you can see, there is a comma after the $ sign. I tested the formula on other computers and the comma doesn't appear anywhere except on my computer. Does anyone have an idea why this is happening? Can it be related to the regional settings of my computer maybe?

    Thanks!

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Formula returning comma after $ sign

    Hi,

    The most likely cause is indeed your regional settings. What is the actual formula you are using and what is the thousands separator for numbers in your regional settings?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    03-23-2016
    Location
    Belgrade, Serbia
    MS-Off Ver
    2013
    Posts
    7

    Re: Formula returning comma after $ sign

    Thanks for the quick answer. After I changed the Digit grouping symbol to "," everything is working fine.

    Thanks again!

+ 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. Trying to create Sign in Sign out sheet with time stamp
    By InNeedOfHelp88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2015, 07:11 PM
  2. Sumifs Statement Returning a #value Sign
    By krunk in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-05-2014, 11:55 AM
  3. Formula to remove the comma sign at end of names
    By zicitron in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2013, 05:55 AM
  4. [SOLVED] If comma present, then place a character before and after comma (FORMULA)
    By jaimealvarez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2012, 04:04 PM
  5. Change comma sign for textbox inputting
    By gandrinno in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2009, 06:18 PM
  6. XL invoice replace the dollar sign with euro sign
    By Pamela casares in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-16-2005, 04:25 PM
  7. [SOLVED] Removing every second instance of comma sign
    By Triple7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2005, 04:06 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