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