It means the number is too long to be dispalyed at your current column width. Doble-Click on the line that appears after the name of the column the ###### appears in but before the name of the next column. Remember, the Columns names are the letters
t
----- Morris wrote: ----
At times, I get ######### when I put a number into an Excel worksheet. What does it mean and how do I get the figure I want?
If you drag the column width to the right and make it wider, you *may* see
your data and eliminate the #'s.
However, if they're still there after widening it a great deal, that means
that you have a *negative date* in the cell.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
At times, I get ######### when I put a number into an Excel worksheet. What
does it mean and how do I get the figure I want?
On a somewhat related note, is there a way I can prevent this? i.e., I type
a date in a field, which through a query causes the worksheet to refresh.
Since I have a large font assigned to the cell I typed in, and the cell
resizes (via the query), I now get #### and have to resize. I know I can
put the cell in a column not affected by the query, but that won't flow with
the design. Is there another way?
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.
