none
Text + Number Formatting Code RRS feed

  • Question

  • Hello -

    Anyone know of a way to accomplish the below? I know there is probably a simple way of doing this, but I can't seem to figure out how to combine a text cell with a numeric cell; while obtaining the numeric cell formatting? See below...


    Any suggestions will be greatly appreciated. Thank you for your time :)


    • Edited by rstreets2 Friday, July 28, 2017 9:23 PM
    Friday, July 28, 2017 9:22 PM

Answers

  • Lol...ok...I was just able to answer my own question :)

    Here's what I came up with that works perfect for what I was looking for....

    =Q34&TEXT(L36,"000000")

    Thank you

    • Marked as answer by rstreets2 Friday, July 28, 2017 11:33 PM
    Friday, July 28, 2017 10:20 PM