Need to see full value returned by a formula without having to expand column.

Try doing this:
Select the range you want this to apply to and then
on the ribbon - click Home > in the cells section click Format > click AutoFit Column Width

Thanks, but this doesn't work because it changes the column width. I would like to keep the columns at the same widths.