Forum Discussion

Copper Contributor

Feb 10, 2021

Format Value in a Textbox

I have a textbox in a chart that displays the value of a cell (D37) in my spreadsheet. Cell (D37) contents are: ="Average Total Intake = "&D36&" kcal". Cell (D36) is the average of some data in the...

excel

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Feb 10, 2021

Ralph_Page Try this:

="Average Total Intake = "&TEXT(D36,"0")&" kcal"

Ralph_Page

Copper Contributor

Feb 10, 2021

Riny_van_Eekelen Perfect, I was not aware of the TEXT function. Thanks

Riny_van_Eekelen
Platinum Contributor
Feb 10, 2021
Ralph_Page Excel has many not so obvious functions. Glad I could help!