If by hash symbols you mean #, then all you need to do is widen your columns
that display them. The indicate that Excel has a number it cannot display
because the column is not wide enought.
Or even:
Format|cells|alignment tab|check shrink to fit.
or change the format of the cell to general. Excel will drop any decimals it
can to try to make it fit in the cell. (But you'll still see #### if the cell
is too narrow for the integer portion.)
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.