How do you set the workbook to expand the cells to the last digit after the
decimal point but not display any trailing zero's?

Example how would you display A1=3.15476 & A2=4.2 instead of A1=3.15476 &
A2=4.20000 without setting the format individually for every cell, and
without any rounding involved?

Thanks,

ben