클래식 파일 유형은 2020 년 12 월 Flash가 종료되면서 지원이 중단됩니다. 중단을 방지하려면 파일을 다음 세대로 전환하십시오. 더 알아보기

Is there a way to make a 0 show up as the word immaterial or not material in the document?

답변함

댓글

댓글 2개

  • Ben Andrews
    I don't think you can do it through formatting.  But it's pretty easy to handle with a formula in your spreadsheet/workbook.  For example, if the 0 were in cell A1, you could put this formula in an adjacent cell:
    =IF(A1=0,"immaterial",A1). 
    then, link the cell with the formula into your document.
    0
  • Alex Pabellon
    That would be your best option, maybe add a numeric range so that it increases its functionality.

    The other options are to:

    1. right click on the linked item and select "format link." At the bottom click on "Advanced." There is an option to "show number as words" and then five options for the number 0: "no," "nothing," "none," "nil," and "zero"


    2. Under the "advanced" option above, there are options for a custom prefix or a custom suffix. It basically appends your desired text to the value of the linked cell. So you might type a suffix with the words "or immaterial" so that the linked cell shows "zero or immaterial." Or a prefix with the word "substantially" so that the cell reads "substantially zero" or something similar.

    The first option is better. The downside is that you have to go back and change the custom language and/or word format if next quarter's value changes. So the IF formula is your most versatile approach.
    0

댓글을 남기려면 로그인하세요.