I have problem with paint icon before I used it the excel calculated nicely but after clicking on the paint icon my data on the row goes haywired. Anyone can give me some solution. Thank you!

Hi
You obviously selected a cell with different formatting when you clicked on the format painter button and applied it to a cell with differing formats.
You can use the undo button to change your cell back to its original.
Hope this helps.
If not then can you post a sample of your issue so we can see what is going on.
Tony