-
Solved: macro for every cell on the sheet
Hi guys I need a macro that will change a number a certain way. It must be able to do this for any cell on the worksheet.
Basically it has to focus on the decimal of the number.
example if number is 203.2 then it should change that to 203.25
If it is 203.4 then it changes to 203.5
if it is 203.6 then change to 203.75
so 0.2 changes to 0.25
0.4 to 0.5
and 0.6 to 0.75
how do i do this? any ideas will be appreciated thanks a lot
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