tinmac 2 Posted August 20, 2012 Hi Mike, I have an auction league with a $2000 cap. The problem I am getting is that with this large a number the cells that calculate anything to do with the cap are not large enough to hold the value and give me the #### for the number. Is there a way I can set the buddy cells to auto size for the value? Thanks, Mac Share this post Link to post Share on other sites
Mike MacGregor 20 Posted August 20, 2012 Hi Mac. It really is just because the columns aren't wide enough, so a pretty easy fix to adjust it. Highlight cells in the column that is showing the ###. Pick near the top of the cheatsheets since those will be the spots with the highest dollar values. Then choose Format > Column > AutoFit Width. Repeat for each column and you'll be good. You could probably even select multiple columns at a time holding down the CTRL key to highlight separate areas. Share this post Link to post Share on other sites
tinmac 2 Posted August 20, 2012 Thanks! That was it, knew it was something easy just couldn't remember where. Share this post Link to post Share on other sites