#######

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
Adjust the column width.

Morris said:
At times, I get ######### when I put a number into an Excel worksheet.
Click to expand...
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?
 
RHinNC said:
Adjust the column width.


What does it mean and how do I get the figure I want?
Click to expand...

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?
 
Back
Top