I have a sheet with that calculates tank coverage based off info that is entered.
From this calculation I have a line that says "Your tank coverage is X sq. ft." The issue I am having is that the X shows up as a text based number (66700) and I would like it to show up as a number (66,700). I tried the DOLLAR function and it formatted it properly except that I do not need the $. Cannot find another function that allows for a similar format without the $...
As you can see in the photo below, the user enters tank size in column C. Based off info in the above rows, it calculates the coverage in Column D. To simplify numbers I did the ROUNDUP function in Column E. Then I converted to sq. ft. by multiplying E * 1000, column F. The amount in F gets populated over to B27... (I'm sure there was a simpler way to do this but it's the only way i knew!)
Excel 1.JPG
This photo shows my formulas.
Excel 2.JPG
Let me know if have the value of 66,700 is possible for cell B27...
Thanks,
Tom
Bookmarks