+ Reply to Thread
Results 1 to 4 of 4

How to change numbers to negative numbers specific with a text

  1. #1
    Registered User
    Join Date
    08-22-2012
    Location
    Bhubaneswar
    MS-Off Ver
    Excel 2003,2007
    Posts
    95

    Wink How to change numbers to negative numbers specific with a text

    Hello Sir,

    i am just confuse to convert the number to negative number using with specific text

    in ColumnA i give some Text like Shortage, Damage

    When i enter the number in ColumnB then the Number must be negative when the Specific Text is not Mention in the ColumnA then the ColumnB Number is normal mode

    With Regards

    Patnaik

  2. #2
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Kolkata, India
    MS-Off Ver
    Excel 2003/2007
    Posts
    182

    Re: How to change numbers to negative numbers specific with a text

    Hi,

    Could you please explain it with some example or you can attached an excel with desired result to make it more understandable.

    Regards
    taps

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: How to change numbers to negative numbers specific with a text

    Pl see the attached file.
    Worksheet_Change Event is used.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-22-2012
    Location
    Bhubaneswar
    MS-Off Ver
    Excel 2003,2007
    Posts
    95

    Re: How to change numbers to negative numbers specific with a text

    Hello Kvsrinivasamurthy

    Thanks for Valuable Replay

    It's Working great just the few words mistake by me or i forget about that

    Thanks for your replay

    With Regards

    Patnaik

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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