Hi
i wrote a code to format columns based on criteria
1) if cell value is integer (as per cell view) then cell value should remain integer
2) if cell value is decimal with n decimals then cell value should convert to 2 decimal number
3) if cell value is percentage then it should convert into 2 decimal value
my code is perfectly working when i run by using F8. But when i run the code by using F5, then code skipping 1 or 2 columns (which contains %) from each sheet. in the 1st attachment contains the data before run the code. in the 2nd attachment is after running the code. yellow coloured columns not converted to 2 decimal numbers. Please help me. code should convert all percentage columns to decimal numbers in all sheets.
thank you in advance.
regards
shiva
Bookmarks