View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SRV....Frenzy SRV....Frenzy is offline
external usenet poster
 
Posts: 7
Default Change Cell Format

Hi all,

Can you suggets how can i change the format of my cell to accept
percentage with two decimal places?

Since, i am adding a new worksheet in my code, i also need to make
sure that the cells have percentage format... have a look

ActiveWorkbook.ActiveSheet.Range("G5").Formula = "=F5/F15"

I want to change the format of G5 cell

Please, provide the code..

thanks in anticipation..