Ohio-Cincinnati
Options

I need an EXCEL INTERVENTION

Again!!!! WHY WHY WHY am I getting ####### in some cells that are formatted/formulated the same as OTHER cells that are working just fine???

Re: I need an EXCEL INTERVENTION

  • Options
    edited December 2011
    Which formula?  I had to take an excel course this past year, blech...  Anything I can help with?
  • Options
    cjcj05cjcj05 member
    First Anniversary First Comment
    edited December 2011
    Make sure the cell is wide enough--widen the column.  Also use the format painter to assure yourself that the cells are formated exactly alike.  It is the paint brush--click on the correctly formated cell that doesn't have the ##### in it and then double click the paint brush and then click the cells that have the ###.Hope that helps.
  • Options
    edited December 2011
    Okay... so it's as simple as having a large enough space/cell to show the number??? That seems to have fixed it for now. Sheesh... I'll let you know if I have another Excel Emergency :)
This discussion has been closed.
Choose Another Board
Search Boards