copy percentage to new column

**waka** · 11-09-2009, 04:05 AM

Hi,

anyone can help ? i would like to copy my sheet 1 column K which has format cell in percentage and copy over to sheet 2 column K. But it will display decimal places rather then percentage.

below code is i use to copy and paste special value. but its not workin.

Please Login or Register  to view this content.

**DonkeyOte** · 11-09-2009, 04:15 AM

perhaps see:

Please Login or Register  to view this content.

**waka** · 11-09-2009, 04:57 AM

its not working. i encounter error.

**DonkeyOte** · 11-09-2009, 06:18 AM

Not much info with which to work but one approach (in basic terms)

Please Login or Register  to view this content.

change references and sheet names as required.

**waka** · 11-09-2009, 08:56 PM

thanks. worksfine. how to make this thread to solved?

**DonkeyOte** · 11-10-2009, 03:09 AM

Quoting the standard response:

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save