×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Formatting cell to expand numbers

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.

RE: Formatting cell to expand numbers

Since you don't seem to be using the numbers for calculations, why not just enter them as text (start with a space)?

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Formatting cell to expand numbers

Merge the cells in a given row in columns U:X.

RE: Formatting cell to expand numbers

All good answers:
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

Although it's odd there appears nothing in that cell to the right (column V), in which case I'd expect the column U contents to show. Maybe try deleting contents in column V anyway to see if something hidden.

=====================================
(2B)+(2B)' ?

RE: Formatting cell to expand numbers

Quote (electricpete)

Maybe try deleting contents in column V anyway to see if something hidden.

...or delete the entire columns, and then reinsert them.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources