| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change Cell Format
If I don't remember how to do certain things in VBA, I often record a macro
doing exactly what I want and then lift that section of the code. Try it. :) "SRV....Frenzy" wrote: 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.. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change Cell Format
With ActiveWorkbook.ActiveSheet.Range("G5")
.Formula = "=F5/F15" .Numberformat = "0%" End With -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "SRV....Frenzy" wrote in message ps.com... 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.. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change Cell Format
Hi Bob,
Many Thanks.. Saved a lot of my time, Cheers, |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change Cell Format
Hi Bob,
Sorry to bother you again, can you show me how can i sort a column just added to worksheet. It consists of numbers Can we not do something like sort for some range like sort (E5:E15) can you suggest something... |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change Cell Format
Range("E5:E15).Sort Key1:=Range("E15"), Order1:=xlAscending,
Header:=xlNo -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "SRV....Frenzy" wrote in message s.com... Hi Bob, Sorry to bother you again, can you show me how can i sort a column just added to worksheet. It consists of numbers Can we not do something like sort for some range like sort (E5:E15) can you suggest something... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| cant change the cell format it shows too many different cell form | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| Change the format of the cell | Excel Discussion (Misc queries) | |||
| How do I change the default cell format? | Excel Discussion (Misc queries) | |||
Linear Mode
