Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (4)

Sign In or Sign Up now to post a comment!

  • Thank you!

    jonathan92591 8 months ago

  • You are welcome!

    ExcelIsFun 8 months ago

  • what if i wan2 have a centre formatted "-" in place of a blank?

    khurram87 2 years ago

  • I do not know how to place a format unless something is in the cell.

    If you have a zero in each cell instead of a blank, you could use the Accounting Number format without a dollar sign and that would show a "-" for each zero.

    Accounting Number format without a dollar sign looks something like this:

    _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)

    ExcelIsFun 2 years ago

Loading...
Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more