+ Reply to Thread
Results 1 to 10 of 10

Remove a sign from a number

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    Russia
    MS-Off Ver
    Excel 2010
    Posts
    21

    Remove a sign from a number

    Hi,

    I need some help. I have a list of numbers, but the problem is, that all numbers have a $ in front(in the same cell). I want to make a button, which removes $ sign. Can u plz help me..

    The list is huge, thats why i think i need a loop?

    Plz help me

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Remove a sign from a number

    Maybe just select the column and do find and replace?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Remove a sign from a number

    Hello Monica85,

    Welcome to the Forum.

    Since I am not sure what approach you are using, you may try:

    Please Login or Register  to view this content.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  4. #4
    Registered User
    Join Date
    08-26-2013
    Location
    Russia
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Remove a sign from a number

    Thanks^

    That is not working.
    I want to use a button.

    TZabIpE.png

    as written before, the list is huge...

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Remove a sign from a number

    Hello Monica85,

    O.K.

    Please try the attached WorkBook with a Button.

    You may also click on the *(Star) to the far left at the bottom of this post, to add to my Reputation.
    Attached Files Attached Files
    Last edited by Winon; 08-26-2013 at 02:54 PM. Reason: Smiley

  6. #6
    Registered User
    Join Date
    08-26-2013
    Location
    Russia
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Remove a sign from a number

    Your code is working..

    But if i write it like this:


    PHP Code: 
    Public Sub test()

    Cells.NumberFormat "General"
       
    End Sub 
    this one is not working i dont want it to remove the dot sign..example 3.898.8989 if u understand?
    Last edited by Monica85; 08-27-2013 at 10:40 AM.

  7. #7
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Remove a sign from a number

    Hello Monica85,

    In that case, please try it like this.
    Please Login or Register  to view this content.
    You may also click on the *(Star) to the far left at the bottom of this post, to add to my Reputation.

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Remove a sign from a number

    Hello Monica85,

    Thank for adding to my Reputation.

    If you are satisfied with the solution I had given you, then please mark your Thread as Solved.

    Kind regards

  9. #9
    Registered User
    Join Date
    08-26-2013
    Location
    Russia
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Remove a sign from a number

    ^it is not working in my code...

    But how did u make the box around the number in the first code.?

  10. #10
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Remove a sign from a number

    The box around the number was added manually, and is not in the Code. You may remove it.

+ 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. Remove borders and x sign on a userform through VBA
    By Sahonero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2014, 06:56 AM
  2. 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
  3. Minus sign at the end of number
    By cope in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-22-2009, 01:13 PM
  4. Reversing the sign of a number
    By Craig in forum Excel General
    Replies: 1
    Last Post: 02-14-2005, 05:06 PM
  5. [SOLVED] Change negative sign from end of number to the beginning of the number.
    By GORDON SCALES via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2005, 04:07 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