I have a block of cells that need to be "Center Justified" with "Shrink To Fit" when numbers are inputted and "Left Justified" with "Shrink to Fit" removed when text is inputted. The columns and rows are both summed so the text input needs to be ignored by the sum function. Is this doable? Easy?

Thanks,
Pete