none
Include Text to a Numbers Cell

    Frage

  • 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
    Moderator
  • GUZZLR,

    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.

    John

    Mittwoch, 9. Mai 2018 19:44