>Where can I learn all the formating commands from. Anyboby have sample programs that formats data to excel. I am having problems with syntax on selecting cell ranges and formatind cells. Please help

Excel VBA Help file contains all information. You should run 'Custom' MSOffice installation to get it.