+ Reply to Thread
Results 1 to 2 of 2

Find & Replace values displayed as percentages will not work (yet)

  1. #1
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Find & Replace values displayed as percentages will not work (yet)

    In row 6, there's 50 values of all types; text, and numbers.

    Included in the row are values of 10.0%. Perhaps 25 instances, all are 5 characters, entered as displayed. 10.0%.
    Number format is as percentage.

    I want to use find and replace to make them all 5.0%. Result: Excel cannot find any instances of 10.0%.

    I've launched the F&R box, (Match entire cell contents) tried entering the 5 characters 10.0%, or just the 10.

    Excel responds that it couldn't find anything to replace.

    Anyone know what might be causing excel not to find and replace?

    TIA for ideas.

    Pete
    Last edited by PeteABC123; 03-15-2018 at 02:50 PM.

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Find & Replace values displayed as percentages will not work (yet)

    A coworker helped out. need to enter the search as 10%.
    Pete

+ 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. [SOLVED] Find and Replace does not work with formulas
    By dflak in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-15-2018, 04:24 PM
  2. Replies: 1
    Last Post: 02-27-2018, 11:22 AM
  3. [SOLVED] find and replace does not work in a linked cell
    By Judith in forum Excel General
    Replies: 3
    Last Post: 04-12-2016, 10:27 PM
  4. Pivot Chart Value displayed as percentages not working correctly
    By sherry1067 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-19-2014, 12:24 PM
  5. Find and Replace in VBA does not work
    By pitinswiss in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-13-2013, 03:20 PM
  6. Find and replace date in a work sheet
    By pohaku in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 11-18-2007, 07:25 PM
  7. The Find or Replace will not work on a date.
    By Don in forum Excel General
    Replies: 4
    Last Post: 09-30-2005, 09:05 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