Include Text to a Numbers Cell


  • 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

    Mittwoch, 9. Mai 2018 15:18

Alle Antworten

  • GUZZLR --

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

    Dale A. Howard [MVP]

    Mittwoch, 9. Mai 2018 16:17

    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.


    Mittwoch, 9. Mai 2018 19:44