On Sep 3, 10:08 am, Kmurray wrote:
I tried the CTRL ~ before, and it just widens the column to show the actual
formula like it normally would. Format is Text and I even did the data text
to columns to verify formatting. The same formula will work a couple of
columns over, makes no sense.

See, it shouldn't be formatted Text. Change that to whatever number
format you need. You may have to click in the cell and hit Enter again
after fixing the formatting to make it work.