+ Reply to Thread
Results 1 to 2 of 2

How to delete some characters from right site of numbers in cell

  1. 11-27-2021, 06:19 AM #1
    hendrikbez
    hendrikbez is offline
    Forum Contributor
    Join Date
    09-03-2008
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2021
    Posts
    311

    How to delete some characters from right site of numbers in cell

    Need help
    I have this in cell B2 (-20.1234%)
    How can I delete the 34 and leave the % in, this number change when I refresh, and it must always take out the number
    Reply With QuoteRegister To Reply
  2. 11-27-2021, 06:31 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,428

    Re: How to delete some characters from right site of numbers in cell

    You don't need VBA. Just format the cell to 2 decimal places.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find characters in a cell containing characters and numbers
    By T86157 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2016, 08:21 PM
  2. Macro to delete all text and characters BUT numbers (including decimals) from excel
    By coolruler in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2015, 01:20 AM
  3. Macro to delete row if the first characters are numbers
    By Ilwuen in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-20-2014, 05:14 PM
  4. how to delete first 4 characters in a cell?
    By sami770 in forum Excel General
    Replies: 12
    Last Post: 05-29-2011, 07:01 AM
  5. How to delete all the characters in cell and leave just the numbers?
    By yannipr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-11-2008, 11:23 AM
  6. Delete last 9 characters from a cell
    By Tom K in forum Excel General
    Replies: 1
    Last Post: 03-05-2008, 02:10 PM
  7. delete all the cell that contains more than 25 characters
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 06-07-2006, 07:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1