Excel seems to think cell isn't big enough so 2 digit number looks crazy, no adjustment fixes issue
I have multiple sheets that add together to make a total on the first page. Easy. The numbers are small - 3, 5, 10, nothing big.
On the totals sheet, all the two digit sums are wrapped so that they are very small. I do not have wrapped text on but when I DO wrap the text, it stops wrapping them BUT there's this giant space between the two digits like "1 0" for 10.
I tried everything I could think of - rewriting the formula as a SUM function (rather than this sheet + this sheet + this sheet), making sure each cell is formatted as a number, running "text to column" on each column of data, switching the font, switching the font size, changing the column size manually, double clicking on the columns to have them auto size, turning off shrink to fit, turning on shrink to fit again after, playing with the alignment....
Does anyone know what is going on and how I can solve it?
Adding images (w/ some edits for privacy for my company). Will include the formulas (both versions).
[link] [comments]
Want to read more?
Check out the full article on the original site