Changing multiple nubers in excel Sheet to end in .95

Posted on 2012-09-07
Last Modified: 2012-09-12
We are looking to have all the #'s in the sheet end in .95 and would like a way to be able to do this going forward and be changed to .75 or .22 etc.  We cannot do a replace all as most of these numbers are created from a formula that is reliant on Cell F4.
Question by:r2sphinx
    LVL 43

    Expert Comment

    by:Saqib Husain, Syed
    Add .30 to F4 and all the numbers will end in .95 except for a few which you can take care of manually

    Author Comment

    yes this would seem like a good solution but this is only a small example of the entire worksheet.  There are close to thousands of other cells that we would like to avoid manually going over ...
    LVL 43

    Accepted Solution

    For the other cells you can do a search/replace and for the formulas you can play with the referred cell.

    If there is still a problem can you repost a file demonstrating your problem?

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now