Include Text to a Numbers Cell RRS feed

  • Question

  • Hello All,

    I have a typical Numbers Column that I paste numbers into.  Is there a way I can add a custom field setting in the Formula area to include the words "hrs"

    For example:  40.2 hrs

    Thanks for the help

    Wednesday, May 9, 2018 3:18 PM

All replies

  • GUZZLR --

    No, you would need to use a custom Text field with a formula for this purpose.  Hope this helps.

    Dale A. Howard [MVP]

    Wednesday, May 9, 2018 4:17 PM

    You can only add text to a text field (e.g. Text1). So if you are entering your values into the Number1 field, for example, you can use this formula in the Text1 field

    Text1 = [Number1] & " hrs"

    Don't forget to "use formula" for calculation at task and group summary rows.

    Hope this helps.


    Wednesday, May 9, 2018 7:44 PM