| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change cell format using vba
Hello All,
I would like to know how to change cell format using vba. Please give me suggestion. Thank you, March |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change cell format using vba
The macro recorder can be your friend. Record a macro while doing it. Then
clean it up if desired. -- Don Guillett Microsoft MVP Excel SalesAid Software "March" wrote in message ... Hello All, I would like to know how to change cell format using vba. Please give me suggestion. Thank you, March |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change cell format using vba
You would use the NumberFormat property for the range of cells you want to
have the same format. See the help files for the NumberFormat Property for some examples. Rick "March" wrote in message ... Hello All, I would like to know how to change cell format using vba. Please give me suggestion. Thank you, March |
| 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 | |||
| How do i change format of cell from 02.02.08 to 02/02/08? | Excel Discussion (Misc queries) | |||
| Change Currency Format of Cell based on another Cell | 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) | |||
Linear Mode
