Formatting cell to expand numbers
Formatting cell to expand numbers
(OP)
Hi all,
I'd like to format a cell so that numbers are expanded over adjacent empty cells rather than abbreviated as pound signs (#) when the cell is too narrow. It does this automatically for text but not for numbers. If I change the cell format to "Text" it automatically widens the cell for the whole column which I was hoping to avoid.
Anyway, I encountered this problem because I am trying something new where I don't adjust the cell widths if possible. Normally I would just widen the cell to fix this display problem.
Any suggestions would be appreciated. I am just trying to create a form that can be printed out as pre-formatted pages of an exhibit in a report.
I'd like to format a cell so that numbers are expanded over adjacent empty cells rather than abbreviated as pound signs (#) when the cell is too narrow. It does this automatically for text but not for numbers. If I change the cell format to "Text" it automatically widens the cell for the whole column which I was hoping to avoid.
Anyway, I encountered this problem because I am trying something new where I don't adjust the cell widths if possible. Normally I would just widen the cell to fix this display problem.
Any suggestions would be appreciated. I am just trying to create a form that can be printed out as pre-formatted pages of an exhibit in a report.





RE: Formatting cell to expand numbers
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Formatting cell to expand numbers
RE: Formatting cell to expand numbers
Another approach: Remove stuff in the cell to the right and you won't get the ###.
Actually you need to do that for any solution that will extend past the cell right boundary... excel won't cover up data in the cell to the right no matter what you do.
=====================================
(2B)+(2B)' ?
RE: Formatting cell to expand numbers
=====================================
(2B)+(2B)' ?
RE: Formatting cell to expand numbers
...or delete the entire columns, and then reinsert them.