Changing multiple nubers in excel Sheet to end in .95

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.
9-7-12.xls
r2sphinxAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
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?
0
 
Saqib Husain, SyedEngineerCommented:
Add .30 to F4 and all the numbers will end in .95 except for a few which you can take care of manually
0
 
r2sphinxAuthor Commented:
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 ...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.