View Single Post
 
Old 11-09-2011, 09:00 AM
4thangel 4thangel is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Nov 2011
Posts: 5
4thangel is on a distinguished road
Default

If marco's are not a problem, you may go for the format painter in a macro. See attached. change format of the input cell and press the button
Hope this is helpfull

Paul
Attached Files
File Type: xlsm formatcells.xlsm (18.5 KB, 23 views)
Reply With Quote