Change Cell value format in all sheets based on multi conditions

HI,


I want to run the vba code through all worksheets to change cell value format (as per cell view) to Integer / 2 decimal number.


Example:

in "Store MTD" Worksheet (C column), we can see C2 , C4 cell values are 3.25 & 0.923076923076923 respectively (in formula bar ), But code should return those cell values as 3,1 (based on our view towards cell).

if the cell value is integer then code should return integer number

if the cell value is decimal number like 34.5574893 or 23.82 then code should return as 34.56 / 23.82

if the cell value is percentage like 34.76% / 0% / 80%/100%/30.00%/23.654555% then code should return as 34.76 / 0/ 80/100/30/23.65


thank you in advance.


Regards
Shiva

Try:

Please Login or Register  to view this content.